Update Form

[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

 

[Jeanette Cunningham]

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