Update list box

  • Thread starter Thread starter Buddy
  • Start date Start date
B

Buddy

I have a list box that is populated by table 'a' and next to the list box I
have an event button that when clicked on will open a seperate form to
update table 'a' which populates the list box.
my goal is that if what you are looking for is not listed in the list box
then you can add your selection to the table 'a', then close out that form
and be right back where you left off on the first form with the list box.
my problem is that after i add new data to table 'a' the list box is not
automatically refeshed. how do i get the list box to automatically refresh
after adding new info to table 'a'?

thanks in advance to any help.
 
Hi,
Somewhere in your code, after you've added the new entry, you must have:
Forms!yourFormName!yourListboxName.Requery

substitute the correct names
 
Brilliant...

Thank you very much.

Dan Artuso said:
Hi,
Somewhere in your code, after you've added the new entry, you must have:
Forms!yourFormName!yourListboxName.Requery

substitute the correct names
 
Back
Top