Microsoft® Office Access™ 2007 Plain & Simple

Creating a Subform

When you create a form that shows the records from a table on the "one" side of a one-to-many relationship, you can create a subform to display records from the table on the "many" side of the relationship. You can also change how the subform displays its records. If you want to see the records as a datasheet, you can change the subform’s view so that it displays the related records while making best use of the form’s space.

Add a Subform

1. Open a form based on a table on the "one" side of a one-to-many relationship in Design view.

2. Click the Design contextual tab.

3. Click the Subform/Subreport control.

4. On the form, drag to define the ...