I am using Microsoft Access 2007. I have a list in a dropdown combobox (Field_One) in a form (Form_One). Users have the option to click a button if the item they need does not appear in the combobox, and another form, (Form_Two) opens to which they can add the new item (in Field_Two).
After adding the new item in F_Two I want the combobox in F_One to requery without having to close and reopen F_One.
I think I can do this with an After_Update event, but to which object should the event apply? Or is there a better way to do it?
Thank you