Pop Up Form

[E.C.]

Hi,
I need some help with a pop up form. I have a form based on tblBid
that is using BidID as a primary key and has some information
pertaining to bids. One combo box has three choices: Yes, No,
Pending- When the user enters "No" I want a blank form to pop up where
the user has to enter the reasons for "No". And once the pop up form
is completed and closed I want the information to be updated in tblBid
to the corresponding BidID. (The pop up form is also based on the
same table).

I have gotten to the point where the form is popping up but once info
is entered its not linking to the BidID on the main form.

Can someone please point me in the right direction?
Thanks in advance- I really appreciate it.

 

[Beetle]

Open your pop up form using the WhereCondition argument of
the OpenForm method to pass the BidID, and open it in Dialog
mode which will halt the code until the pop up form is completed and
closed (or hidden), then Requery your main form;

DoCmd.OpenForm , "frmYourPopUp", , "BidID=" & Me!BidID, , acDialog

Me.Requery