Office 2010 - Access

Lesson 38: Using Subforms

38/76 Lessons 

What are subforms?

A “Subform” is a form which is related to a main form. A “Subform” shows data related to, the data in the main form.

Automatic Subform

In “Access” 2010, a “Subform” (2) is added automatically to the form, when we create it by clicking on the “Form” (1) button. At least when this table is associated with a different table.


If you want this “Subform” not to be added to your form, select it and click the “Delete” key on your keyboard.

Subform with the Wizard forms

Even when you create a form using the “Forms wizard”, we can add a “Subform”.

Choose the “Create” tab and click the “Form Wizard” button.

In the first wizard window, select the table you want as “Main Form” (1) and you place the fields you want from this table, in the right panel.

Then select a new table (2) if you want to use this for your “Subform” and place these fields also in the right pane.

Click the “Next” (3) button.

In the next window, check the “Form with Subform” (4) box.

Click the “Next” button.

In the next window, choose the layout for the “Subform” (5) and click the “Next” button.


In the last window of the wizard, give the “Form” and the “Subform” names and click the “Finish” button.

We have just created a “Form” with “Subform” using the “Forms wizard”.


You've completed Lesson 38