Pop up form record sync'd with main form 1

[Steve1445]

I have a field in a form I have set for an action of a double click to start a pop up form. How do I tie the two together, so that I see the same record's information in both forms.

Example, the main form has a companies physical address, while the pop up form has the companies mailing address.

I have established relationships, however I'm not getting anywhere doing that. Maybe I'm missing something.

Thanks in advance.

 

[LonnieJohnson]

In the openform command you can set criteria for a unique field. Lets say the company ID, which I will call Id.

DoCmd.OpenForm "FormName", , , "[Id]=" & "'" & Me![Id] & "'"

B-)
ljprodev@yahoo.com
ProDev, MS Access Applications

http://www.galaxymall.com/software/PRODEV

 

[Steve1445]

Worked great! Thanks.