How to Create a Subform in Access ?
What is a Subform?
A subform in access is essentially a form within another form, also referred to as a parent/child form or master/detail form. Subforms are particularly useful for displaying data from tables or queries that have a one-to-many relationship.
How to Make a Subform
- First, open the database window.
- Click on "Forms" in the Objects task pane and then click the "New" button on the toolbar to open a New Form dialog box.
- Double-click "Form Wizard".
- From the list, select "Tables/Queries". Double-click the fields you want to add to the form from the Available Fields list.
- Do not click "Next" just yet.
- Select a second option from the Tables/Queries list, double-click the fields, and add them accordingly.
- Ensure that the relationships between the two tables or queries are set up correctly, then click "Next".