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
Select the "Create" tab and choose the "Forms" group.
Select "Form Wizard."
Select a table or query to link your form to.
Double click the fields you want to add to the form.
Select a second table or query for your subform.
Double click the fields you want to add to the subform.
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.
Select "Form with subform(s)."
Choose a layout option for your subform.
Enter titles for both the form and subform.
Choose your view type and press "Finish."
Create with Form Wizard
Right click the form you want to add a subform to in the Navigation Pane.
Choose "Design View."
Choose the "Design" tab.
Click the drop down arrow in the "Controls" group.
Before selecting any controls, ensure "Use Controls Wizard" is selected.
Click once on your form in the location you want to add the subform.
Follow the subform wizard to add the subform.
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.
Create from Existing Form
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for