Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking to a subform ID

Status
Not open for further replies.

Tash

MIS
Nov 3, 2001
62
US
How can I link to a field from Form1 to Form2's subform? I have a search button on Form1 that links to the ID number on Subform2, but the error message says it doesn't exist. Thanks in advance for any help with this!

This is what I have so far:

[Forms]![Form1]![ID]= Forms![Form2]![subform].Form![ID]
 
Try the following:

When you are on the master form (form 1), click on the edge of the child subform (form 2) and go into the properties. Click on the Data tab. There are two fields: Link Child Field and Link Master Fields. If you click in either of these two places, a button with "..." will appear. Click on it and a box will show up. Choose the fields that will link the two forms, click OK and you should be all set.
 
Actually, my Form 1 is a completely different form. Form 2 already links up (child/master)with it's subform. I want to put a button on Form 1 that will link me to information to the Subform of Form 2.

What I have is a search list on Form 1 that has minimal information. I have a button on each record in Form 1 that will lead the user to more detailed information on Form 2. However, I need the right subform to appear on Form 2 when it opens.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top