Combo box update

[REDaughdril]

I have a form that I use a combo box to pick a "department". When the department in no listed in the combo box I have a pop form to enter that department.

My question is, how do I get my new "department" to be updated in the combo box so that I can select it. With out closing the form and reopening it (it works when I do that) Some type of update or requery.

Or how do I get the "Department" name that I entered in the pop form to be entered in the combo box.

Thanks for the help!

 

[Rich]

use the NotInList event, example code has been posted here