Requery the combo box

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Hi,

I use a buttom on my main form to call another form to add new contacts to
my contacts table. I have a combo box on the main form to display the
contacts name. But I have to close the main form in order to see the new
changes. How do I requery the combo box to see the new changes?


Thanks for any help
Richard
 
Richard

Unless you tell Access to requery the combobox, it doesn't know you added
records.

cboYourCombobox.Requery

could be the last line in your command button's code.

Alternatively, you could use the LimitToList property of the combobox, and
the NotInList event to pop that form open, accept the new information, and
automatically refresh/requery the combobox on return (see Access HELP re:
NotInList). No command button needed...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top