O'Reilly logo

2007 Microsoft® Office System Step by Step, Second Edition by Joan Lambert, John Pierce, Steve Lambert, M. Dow Lambert III, Curtis D. Frye, Joyce Cox

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

Adding a Subform to a Form

A form can display information (fields) from one or more tables or queries. If you want to display fields from several tables or queries in one form, you have to give some thought to the relationships that must exist between those objects.

In this exercise, you will add a subform to an existing form.

Note

USE the AddSubform database. This practice file is located in the Documents\Microsoft Press\2007OfficeSBS\AccessSimplifying folder.

OPEN the AddSubform database. Then open the Categories form in Design view.

  1. Drag the Form Footer section selector down about 1 inch to give yourself about 3 inches of vertical space to work in the Detail section of the form.

  2. On the Design tab, in the Controls group, make sure the Use Control ...

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