Discussion Locked

Don't know how

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I know it is possible but I don't know how. First, I have a form with 2 tabs that I want to link the controls in tab1 to table1 and the controls on tab2 to table2.

2 replies

by timfox

If I understand your description properly, you have a tab control with two tabs and want each tab to have an individual dataset (ie. different tables or queries for each tab).

This is done by combining 3 forms. The first form is your main form with your tab control. The second and third forms are what the user would see when they click on each of the tabs. Design these 2 forms first and include all necessary fields etc (using the form wizard if needed). Then open the form with the tab control and add a subform object from the object toolbox to each tab. In the 'Source Object' field on the subform's properties, enter the form name for either the first or second form that contains the fields etc.

Let us know if this is not clear enough- hope this helps

TimFox

by john_wills

I imagine that you have some reason for having both tables on the same form; presumably by clicking tab the user should get something on the new page connected to what is on the first page. Set up a query for the entire form, joining the two tables at the appropriate column pair, then place the controls from each table on the appropriate page.

This discussion is closed to new replies.