Add an existing form to another existing form to create a form with a subform
Before using this procedure, make sure you've set up your table relationships correctly.
- Open the form that you want to use as the main form in Design view. This is usually a form based on a table or query on the "one" side of a one-to-many relationship.
- Make sure the Control Wizards tool in the toolbox is pressed in.
- Press F11 to switch to the Database window.
- Drag a form, table, or query from the Database window to the main form.
Microsoft Access adds a subform control to the form. If you dragged a form displayed in Form view, Microsoft Access displays the subform in that view. If you dragged a form displayed in Datasheet view or a table or query, Microsoft Access displays the subform as a datasheet.
Notes
- For information on changing the layout of a subform, click .
- For information on troubleshooting subforms, click .