Call data into subform within a form

[pwelch]

Hi, I am modifying a form that already has the "Go To" drop down box to recall the data in the top part of the form. I have added two subforms to the form that I want to populate the informaiton associated with the data that is called into the form. How can I do this? Can I just modify the dropdown macros? I am not very proficient with macros. Thank you!<br><br>&nbsp; &nbsp;&nbsp;<img src="https://www.accessforums.net/attachment.php?attachmentid=28064&amp;stc=1" attachmentid="28064" alt="" id="vbattach_28064" class="previewthumb">

[Bulzie]

Is there a reason you are using a tab control if you only have 1 tab or are you going to add more?

To get data in the subforms, use the LinkMaster and LinkChild properties on those subforms. The linking key field from the main form goes in the LinkMaster box and the same field in the subforms would go in the LinkChild. So lets say mainform key field is EmployeeID, you should have an EmployeeID field also in the tables of your subforms which again would go into the LinkChild.

[pwelch]

Thank you for your help! I will try the LinkMaster.
The form already had the tab control but only had the 1 page. I tried to add 2 more tabs and put the subforms there, but they kept superimposing over the first page in form view. I even created the subform through the controls with the tab highlighted and it would not work, so I opted for this version.

[Bulzie]

If you are not going to add more tabs, I would get rid of it as with the tab control, anytime you reference anything you have to go through that tab control syntax. Basically if you wanted to do that(make sure you have a good copy of the database first), you just need to copy all the fields at the top and the 2 subforms, delete the tab control and paste them directly into the detail section.

[pwelch]

Thanks again. I will try that. The masterlink worked so easily! Thanks!