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 07_AddSubform database. This practice file is located in the Chapter10 subfolder under SBS_Office2007.

OPEN the 07_AddSubform database. Then open the Categories form in Design view.

  1. Drag the Form Footer section selector down about 1 inch to give yourself some room to work in the Details section of the form. It should be about 3 inches high.

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

Get 2007 Microsoft® Office System Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.