Dynamically updating items in a databound combobox

[dan.neely]

I want to be able to select values from a combobox to edit entries in
a table and also allow the user to enter new entries into the table
that the field using as a foreign key. I can use a child form to
enter new data into the table that's being used as a foreign key in
the main one, but I can't find a way to refresh the combobox to show
the newly available selections without closing and reopening the form.

 

[Marshall Barton]

I want to be able to select values from a combobox to edit entries in
a table and also allow the user to enter new entries into the table
that the field using as a foreign key. I can use a child form to
enter new data into the table that's being used as a foreign key in
the main one, but I can't find a way to refresh the combobox to show
the newly available selections without closing and reopening the form.

The form for entering a new item must be opened in dialog
mode. Then the OpenForm line can be followed by:
Me.combobox.Requery
If you are using the NotInList event to do that, ne sure to
set the Response argument.