Refresh on form close using VBA

[gsandy]

I have combo box that lists data from another form (frmCity) . If the required data in not in the list then frmCity is opened, a new record is entered and form closed. The combo box in the first form (which has remained open) does not show the new entry unless it is closed and re-opened. How can I get the new record to show without closing and reopening?

Thanks Sandy

 

[Catalina]

How about re-querying the combo box upon closing frmCity?

In the OnClose Event of frmCity try:

Forms!FirstForm!MyCombobox.requery

Replace FirstForm and MyCombobox with the actual names.
You can also put the code behind a close button on frmCity

 

[gsandy]

Thanks Catalina that worked fine. Cheers Sandy

 

[Catalina]

You're welcome, I'm glad I could help.