Combo Box Refresh

[grantc]

Hi Everyone
I have a "pop-up" form attached to a main form that allows users to add items to a combo box on the main form. How do I get a new item added via the "pop-up" form to appear in the combo box without closing and re-opening the main form ?
Thanks in advance.
Grant

 

[evalesthy]

I'm on the run - but try either 'Refreshing' the main form on close of the popup form. Or, try 'Requerying' the combo control on close of the main form. Find details of either method under Access Help. I will check back later to see if this worked for you.

 

[jimmythegeek]

On the close event of the pop-up form, put the following:

Forms!MainFormName!ComboBoxName.Requery Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?

 

[grantc]

Thanks, works like a charm !