Refresh information

  • Thread starter Thread starter Alberto
  • Start date Start date
A

Alberto

I have a form where I insert information in a table "A" but in a particular
field the value must be read from another table "B" (using a combobox) but
if the value we are looking for doesn't exist, it must be created using
another form.

After create the new value in the table "B", I return to the previous form
but the
value isn't there. I need to close the window and open it again to see the
new data
in the combo.

How can I refresh the information? I tried to do it with the DoCmd.Requery
but it
doesn't work.

Thank you.
 
Thank you very much.

Steve said:
Sorry, I didn't notice that you said that requery didn't work! I think
Click to expand...
that the me.requery will refresh the form's underlying data source, perhaps
you can do something like this: me.Combo_box.Requery
 
The code below works! I have had the same issue. Thanks Chris

Combo1.Rowsource = Combo1.Rowsource
Combo1.Requer
 
Back
Top