Updating field lists in forms

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

Guest

Hi

Wonder if someone could help. My database has a form that one of the fields
in the form is a drop down menu, and you select what data you want. This drop
down menu is populated by a table. From the form, I have a command button
that takes me to another form, that allows me to add to this table, but when
I return to the origonal form, the new value is not there until I close then
re-open the form. Is there any way of getting the form to automatically
update the new value into the field list, without having to close and repoprn
the form. I have also tried linking the table where the new value is added,
to the table the main form populates, with a one to may relationship, that
updated cascaded fields, but no luck.

Any help would be appreicated.
 
Have you tried a Requery of the combobox when you return from the other
form?
That should do it.
Al Camp
 
You can do away with the command button to add a new record to the combo box
if you set the "Limit to List" property of the combo box to "True". The
"NotInList" event allows you do whatever you want when the user enters
something that's not in the list, like automatically open the other form and
have the user enter the new information. When they close that other form,
you can automatically requery the combo box and the new value will show up.
 
Back
Top