list box not updating until form loads

[cowboy]

I have a list box that displays the names of all the records. When I add, edit, or delete a record the list box does not update itself until I leave the form and come back into the form. How do I make it update when I Add a record?

Some useful information
Row Source:
SELECT Inspections.ID, Inspections.[Number] FROM [Inspections Query];

AfterUpdate [Event Procedure]:


DoCmd.GoToRecord acDataForm, "StormDrainMHForm", acGoTo, lstMH.ListIndex + 1

Thanks for any help.

[pbaldy]

Try

Me.ListboxName.Requery

[cowboy]

Where should I put that? Maybe the before update of the text box to enter the ID?

[pbaldy]

Not sure what you're doing that would then require the requery. The after update event of the form would catch changes to records and new records, but I don't think it fires when a record is deleted. For that you could use the delete event of the form.