Linking Separate Forms

[JusticePC]

Hello,

What I am attempting is to bring up a form from a control on another form. This form is not a subform, but I would like it to contain information that links to records in the main form. I.E. I have a list of Girl Scouts, and I want to pop up a form by pressing a button on the main Girl Scout Roster form. On that form, I want to record the individual sales of cookies.

Unfortunately, the sales form is too big to be a subform... How do I link the form so that when I enter new girl scout sales information, it automatically fills in the name of the Girl Scout from the Main form to the popup form?

 

[JusticePC]

For clarification... I already have the separate tables linked in a relationship, but when I bring the secondary form up, I can't figure out how to assure that it links to the currently open record on the main form.

 

[David R]

What you're doing is very possible, and I believe there is even a wizard for it. Two help topics to get you rolling:
"Create a pop-up form or custom dialog box" and "Synchronize records between two forms".

Post back if you have further troubles,
David R