Subforms

MS Access: Subforms

A subform is a form within a form. It is generally used whenever you want to display data from multiple tables where there is a one-to-many relationship.

For example you would use a subform if you wanted to display an order with the order details. In this case, the order information would display on the "main" form and the order details would display on the subform.

TUTORIALS

• TUTORIAL: VBA Basics (Understanding the VBA environment) in Access 2007 | Access 2003/XP/2000/97
• TUTORIAL: Debugging VBA Code (Understanding VBA's Debugging Environment) in Access 2007 | Access 2003/XP/2000/97

Navigation Pane (Access 2010 and 2007)

• Display forms in the Navigation Pane in Access 2007
• Display all objects (tables, queries, forms, reports, modules) in the Navigation Pane in Access 2007
• Display tables and related objects in the Navigation Pane in Access 2007

Miscellaneous

• Link a subform to a form in Access 2003/XP/2000/97
• Popup calendar in a form/subform in Access 2007 | Access 2003/XP/2000/97
• Populate subform data automatically (one to many relationship) in Access 2003/XP/2000/97
• Refresh the contents of a subform whenever the record in the main form changes in Access 2003/XP/2000/97
• Display a particular subform based on a combo box selection in Access 2003/XP/2000/97
• Set the focus on second field in a subform whenever a record is viewed in Access 2003/XP/2000/97