tab control data source
- Thread starter eugz
- Start date
Yes, it is possible.
Look at "DemoTabControlA2002.mdb" (attachment, zip).
There you can see 3 tables, (tblMain, Table1, Table2), 3 forms,
MainForm (with 2 tabs) linked on the tblMain, Subform1 linked on
the Table1, and Subform2 linked on the Table2.
Look at the "Relationships".
Subform1 and Subform2 are linked with MainForm via "Link Child Fields" and
"Link Master Fields" properties, (fID, f1Num and fID, f2Num).
Adapt it in your mdb.
Look at "DemoTabControlA2002.mdb" (attachment, zip).
There you can see 3 tables, (tblMain, Table1, Table2), 3 forms,
MainForm (with 2 tabs) linked on the tblMain, Subform1 linked on
the Table1, and Subform2 linked on the Table2.
Look at the "Relationships".
Subform1 and Subform2 are linked with MainForm via "Link Child Fields" and
"Link Master Fields" properties, (fID, f1Num and fID, f2Num).
Adapt it in your mdb.
- Local time
- Today, 02:06
- Joined
- Feb 28, 2001
- Messages
- 30,564
To amplify MStef's answer, yes and no.
Yes, you can have multiple tables, one on each tab of a multi-tab form. One tab can be based on the parent table (or the parent can be on a non-tabbed part). The other tabs can be based on child tables of the parent table.
No, you cannot have INDEPENDENT multiple tables. The tables feeding the tab pages must be related to the table that feeds the form itself.
Exception: If the main form is unbound, the tabs can do some pretty wild things, but then you face the headache of having to muck about with unbound forms. Which is its own form of torture.
Yes, you can have multiple tables, one on each tab of a multi-tab form. One tab can be based on the parent table (or the parent can be on a non-tabbed part). The other tabs can be based on child tables of the parent table.
No, you cannot have INDEPENDENT multiple tables. The tables feeding the tab pages must be related to the table that feeds the form itself.
Exception: If the main form is unbound, the tabs can do some pretty wild things, but then you face the headache of having to muck about with unbound forms. Which is its own form of torture.
