Add an existing form to another existing form to create a form with a subform

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.

  1. 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.

  2. Make sure the Control Wizards tool in the toolbox is pressed in.

  3. Press F11 to switch to the Database window.

  4. 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