Create a form with a subform that contains another subform

Before using this procedure, make sure you've set up your table relationships correctly.

You can use this procedure to create a form and two levels of subforms that have a one-to-many relationship. The main form has a one-to-many relationship with the first subform, and the first subform has a one-to-many relationship with the second subform.

1. Create a form with a subform.

   How?

   Note   Make sure to select the Tabular (the equivalent of Form view) option when the wizard asks what layout you want for the subform. If you select the Datasheet option, you won't be able to insert a subform inside the subform.

2. In Design view of the main form, make sure the subform control is selected. After it’s selected, you can click again inside the control to select the form, a section, or a control, just as you would if you opened the subform in Design view from the Database window.
   
   
3. Do one of the following:
   • Use the Subform Wizard to create the second subform.

     How?

   • Drag a form, table, or query from the Database window to the subform.

     Microsoft Access creates another subform inside the first subform and creates a form for the subform.

4. Switch to Form view to see the form and subforms.

Notes

• For information on changing the layout of a subform, click .
  
  
• For information on troubleshooting subforms, click .