Data Update Problem

[Nosaj08]

Hello Everyone,


I seem to be running into an issue with data updating on my forms. Basically, what I have is a database to hold a bunch of event info and on one form, I have a Tab Control to view events by their status, e.g. canceled, completed, tentative, ect. On one of the tab pages, I have a button that opens a second form to change the event's status and on that form, a button to save and close. When this happens, the data updates correctly in the table, but the initial first form, with the tab control, does not display the updated information in my List Boxes until you close out of it and reopen it. Is there a button to update the data in the list boxes in the tab control without having to close and reopen the form? I have tried the Refresh command but that gives me an error saying "The Command or Action 'Refresh' isn't available now." Any thoughts would be appreciated. TIA!

Jason

[RuralGuy]

You can Requery a ListBox.

[Nosaj08]

Great, thanks again.

I just added a requery command for all of the list boxes to my back button and it works perfectly.

Jason

[RuralGuy]

Excellent and you're welcome. Go ahead and use the link in my sig.
Oops! I see you already did. D'oh!