What Do You Know about Subform?
What is a Subform?

A subform 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

1. First, open the database window. 2. Click on "Forms" in the Objects task pane and then click the "New" button on the toolbar to open a New Form dialog box. 3. Double-click "Form Wizard". 4. From the list, select "Tables/Queries". Double-click the fields you want to add to the form from the Available Fields list. 5. Do not click "Next" just yet. 6. Select a second option from the Tables/Queries list, double-click the fields, and add them accordingly. 7. Ensure that the relationships between the two tables or queries are set up correctly, then click "Next".

Have a question? Ask us!