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

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

"Bro C." <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>