Dynamically updating items in a databound combobox

  • Thread starter Thread starter dan.neely
  • Start date Start date
D

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.
 
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.
Click to expand...


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.
 
Back
Top