updating a control

[Seven]

I have a form which has a combobox. Next to the combo is a button. when the button is hit it will open another form for data entry.



if the combobox is empty, then the button will open a form and start a new record

if the combobox has a value in it, then the button will open a form to the correct record (corrosponding to the combobox value)

the form that the button opens modifies the table that the combobox data
is picked from.

all of this works as expected. now for the question :

when the user returns to the original form, how do I get the combobox to 'update' the available values from the table that the other form just modified? ( I prefer to not do this as i close the other form, but rather put some code in to update the combobox when the original form regains focus ) for example, if the user creates a new record, and then closes the form, the combobox does not have the new record as a choice.....

something like

on event gainfocus : me.mycombobox.rebuild your list()

any help would be greatly appreciated!

[RuralGuy]

Why not just put a Me.ComboBoxName.Requery in the GotFocus event of the ComboBox? Then every time you enter the cbo, it will requery.

[Seven]

will give it a try on monday. thanks for the assist!

[RuralGuy]

Another method would be to use the acDialog argument in the OpenForm command to stop the code in the first form. Then make the next line force the cbo to requery.