Form refresh! Help. (1 Viewer)

yahazim

Registered User.
Local time
Today, 21:54
Joined
Apr 2, 2001
Messages
24
FORM-A has a combo box that references a primary key of TABLE-B and fills in the associated information in the fields below the combo box. I need to add an entry to TABLE-B that is associated with information I just entered into FORM-A. I go to FORM-B, enter in the new record so it fills into TABLE-B, I go back to FORM-A, and I need to refresh the combo box on FORM-A. I click on a command button that I created to refresh the form, but FORM-A will not refresh because it needs the combo box filled in (it references a primary key). How do I get the combo box that references TABLE-B to refresh, without needing to close and reopen FORM-A?
 

KevinM

Registered User.
Local time
Today, 21:54
Joined
Jun 15, 2000
Messages
719
Try using....

Forms!FormA!ComboBoxName.Requery

On the afterupdate or afterinsert event on FormB.

hth
 

Users who are viewing this thread

Top Bottom