refresh list box

  • Thread starter Thread starter Andrew
  • Start date Start date
A

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!
 
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.
Click to expand...

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

Larry Linson
Microsoft Access MVP
 
Back
Top