Fast forms with subforms

- [Instructor] Subforms are a great addition…to forms you use for data entry…or to simply look up records in your database.…They're helpful because they typically contain data…from a related table,…meaning you can see the contents of two tables at once…in a single form.…If you build your forms…after setting up your table relationships,…you'll get subforms automatically.…Here we see the Instructor form has a Classes subform…because the Instructors table is related…to the Classes table.…To add a subform when one has not appeared automatically,…open the form in Design View.…

I've opened the Classes form in Design View,…and using the subform button in the Controls group,…I draw a box, which invokes the Subform Wizard.…I choose to base the subform…on an existing Instructors Form.…And next I choose to build the subform…from a list of the fields in the selected form.…After naming the form, I can switch to Form View,…and I see that the classes…to whom an instructor has been assigned now include data…in the subform for that instructor.…