Microsoft Office Tutorials and References
In Depth Information
Using a Subform to Display Detail Records
Figure 4-4:
A subform
shows
the list of
products for
one order.
Before you create a subform, make sure that the table containing the data
to be displayed by the proposed subform is on the “many” end of a one-to-
many relationship with the table that is the source of data for the main form.
Book II, Chapter 6 shows you how to tell Access about the relationships
among tables by using the Relationships window.
A subform can have its own form layout and navigation buttons for moving
around the records within the subform. One form can have more than one
subform if data from more than one table on the “many” end of a one-to-
many relationship with the primary table is displayed in the main form.
Each subform is stored as a separate form in Access. You see the subform’s
name in the Navigation Pane. You create a subform the same way that you
do a regular form because it is a regular form. To display it as a subform, you
create a subform control on the main form, showing Access how and where
you want the subform to appear on the main form.
Creating a subform
The easiest way to create a form is to use a wizard (surprise, surprise!). You
can always edit and improve the subform later. (If you’re creating a report,
see the section on subreports in Book V, Chapter 1.)
Search JabSto ::




Custom Search