adding a new record from a combo box

[Bro C.]

Hi everyone!

I have 2 forms "1stform and 2ndform" I Have a problem requering the
1stform.on the first form a have a combobox that allows me to add a
new record if not on list, when the record is not on list it opens the
2ndform when im finish entering thae new record, it does not show up in
the first form unless i get out of the first form completely and go
back in again, is there a way to have the first form requery when i'm
done entering the new record in the send form


thanks in advance for your help

 

[Larry Linson]

If you use a popup dialog form as the form opened to do the actual data
entry, it will stop code execution until it is finished. So, you can put
your Me.<comboboxname>.Requery as the very next instruction. If you want to
locate the combo to the record just added, save the information prior to
going to the dialog, or store it back into a control on the original form
from the dialog.

Larry Linson
Microsoft Access MVP