Microsoft Access Subform Tutorial

Written by c.d. crowder Google
  • Share
  • Tweet
  • Share
  • Email

Create Microsoft Access forms as a graphical user interface for your database. Users can enter, edit and even delete data through an Access form. To provide users with even more information, create a subform on your Access form. A subform shows related data from a record on your main form. Subforms are mainly used for tables or queries with a one-to-many relationship to show records from several sources on a single form. Subforms can be created along with the form or separately.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

    Create with Form Wizard

  1. 1

    Select the "Create" tab and choose the "Forms" group.

  2. 2

    Select "Form Wizard."

  3. 3

    Select a table or query to link your form to.

  4. 4

    Double click the fields you want to add to the form.

  5. 5

    Select a second table or query for your subform.

  6. 6

    Double click the fields you want to add to the subform.

  7. 7

    Click "Next."

  8. 8

    Choose the one side of the one-to-many relationship when asked "How do you want to view your data."

    For instance, if creating a form and subform for the classes students take, choose the main table or query that lists the essential student information such as student name and grade. Your many side of the relationship would be the student class list.

  9. 9

    Select "Form with subform(s)."

  10. 10

    Click "Next."

  11. 11

    Choose a layout option for your subform.

  12. 12

    Click "Next."

  13. 13

    Enter titles for both the form and subform.

  14. 14

    Choose your view type and press "Finish."

    Create from Existing Form

  1. 1

    Right click the form you want to add a subform to in the Navigation Pane.

  2. 2

    Choose "Design View."

  3. 3

    Choose the "Design" tab.

  4. 4

    Click the drop down arrow in the "Controls" group.

    Before selecting any controls, ensure "Use Controls Wizard" is selected.

  5. 5

    Choose "Subform/Subreport."

  6. 6

    Click once on your form in the location you want to add the subform.

  7. 7

    Follow the subform wizard to add the subform.

  8. 8

    If you already have a form created that you want to use as your subform, drag it from the Navigation Pane to your open form. The main form must be open in Layout View.

Tips and warnings

  • Adding a subform during the form creation process links the two more easily than adding the subform a different way.
  • You cannot create a subform in a form if no relationship exists between the two.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.