O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required