refresh list box

[Andrew]

Hello

I have a customer form that has tabs. On tab A you can
access a popup form to enter data, then the data is
displayed in a listbox on tab c. How do I get the
information to refresh to my listbox when the popup form
is closed? I've added the standard refresh code to the
close button, but the listbox does not get refreshed
until I leave the customer record altogether.

Thanks!

 

[Larry Linson]

I have a customer form that has tabs. On tab A you can
access a popup form to enter data, then the data is
displayed in a listbox on tab c. How do I get the
information to refresh to my listbox when the popup form
is closed? I've added the standard refresh code to the
close button, but the listbox does not get refreshed
until I leave the customer record altogether.

I think you are looking for "Requery" to get newly-added records.
Check VBA Help for "Refresh" and "Requery".

Larry Linson
Microsoft Access MVP