From the course: Access Quick Tips

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Fast forms with subforms

Fast forms with subforms - Microsoft Access Tutorial

From the course: Access Quick Tips

Start my 1-month free trial Buy for my team

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…

Contents