Article ID: 198502 - View products that this article applies to.
This article was previously published under Q198502
Novice: Requires knowledge of the user interface on single-user computers.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
For a Microsoft Access 2002 version of this article, see 324582
You can use the tab control to display linked subforms. A form contains linked subforms when the second subform displays only the records related to the record that you select in the first subform. The Customer Orders form in the sample database Northwind.mdb has an example of linked subforms.
Because a tab control enables you to place different controls on different pages of a single control, you can make better use of available space on the main form and still have plenty of room to display the subforms.
NOTE: This article explains a technique demonstrated in the sample file, FrmSmp00.mdb. For information about how to obtain this sample file, please see the following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/233324/EN-US/ )Microsoft Access 2000 Sample Forms Database Available in Download Center
The following example demonstrates how to create a form with two linked subforms similar to those on the Customer Orders form. The tab control on the main form contains one of the linked subforms on each of its two pages.
For more information about the tab control, please see the following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/208785/EN-US/ )ACC2000: How to Use the Tab Control in Access
Article ID: 198502 - Last Review: January 26, 2005 - Revision: 2.1
Contact us for more help