Update Form

  • Thread starter Thread starter Stefan
  • Start date Start date
S

Stefan

I have a main form which has combo boxes which pull from a table to fill in
data fields.

Sometimes these tables need new data added. I have added a command button
which opens a second form where the list can be updated.

When I close the second form the new choices do not appear in my combo box
unless I close and re-open the form.

Is there a way I can do an automatic refresh or update without having to
close the main form?

Thanks in advance
 
Stefan,
After you have updated the table behind the list,
you can requery the main combo form like this:
Forms!TheMainForm!TheCombo.Requery

replace TheMainForm and TheCombo with your names

Jeanette Cunningham
 
Back
Top