Hi Edwin,
Whenever you add an item to an Access form, it will always be added at the bottom by default. It will only show up in the appropriate sorted location after the form has been refreshed, either by:
1. Closing and opening
2. Hitting the refresh key
3. Some VBA code to force it to refresh

Darrin That is option number 3.

The code to requery I believe is in the part where he goes on about Description_AfterUpdate() that triggers the sort.  I'd like it to requery the MealListF when the Add to Meal... right now it doesn't requery and give us the calories and protien.

Well, I can't recalculate the calories and protein if there are no calories and proteins, so we're going to get there. We got to deal with some issues today about how you can add a food item when a meal doesn't exist yet. So we're still getting there, folks, just be patient.

Jeffrey
I suppose this is the code in the Description_Afterupdate()
Dim TempID As Long
    
    Me.Dirty = False
    TempID = MealID
    MealListF.Form.Recordset.Requery

Well, the meal is added to the meal list, but it's not sorted.
Not even when I close and reopen the form.

In the Form_Load of the MealListF code I added  DoCmd.SetOrderBy "Description ASC" and now it sorts it whe the form is opened.

One of my entries (for some reason) did sort. Maybe it shouldn't have.  I added the sort labels like the ones found on the FoodListF. I did it for no reason other than to do it.  

On mine I messed around with the MealListQry and set sort to assending. Obviously could do the same thing, and I just might.
I'm also adding a search field to see if I've already put the meal in before I decide to put it in a second time.