Update from command button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help please.
I have a form with a combo box that retrives names from a table that
contains name choices and assigns a name to a record in another table. If
the needed name does not show up on the drop down menu the user can click a
button on the form and bring up another form to add the name to the name
table. My problem is that after adding a new name and closing the name input
form the name still doesn't show up in the combo box. If the origional form
with the combo box is closed and reopened then the new name appears. How can
I make the new info show up with out closing and reopening the first form?

Thank you.
 
Steve,
After adding the record to the tablke behind your combobox, do a Requery
on your combobox. Then the new record you added will show up.
hth
Al Camp
 
Back
Top