|
||||||
|
Nested Subforms By Richard Rost 4 years ago How to Create Multiple Nested Continuous Subforms In this video, I'll show you how to create multiple continuous (list) subforms inside of each other. We'll track data for a fictional college and store departments, courses, and classes. So if you want to know in which courses you'll find classes like "Neil DeGrasse Tyson's Favorite Hits" or "Which Captain is Your Favorite, and Why is it Picard?" then you'll be able to quickly locate them with these forms. Elaine from Sante Fe, NM (an Access Expert student) asks: I have someone who wants to enter info for each of the four tables in the database in one giant form. I've created four different forms with continuous subforms. I'm stumped as to how to get them to work together, flowing from the top table selection and then related data showing through the other three tables. How do you set this up? MembersI'll show you how to create another subform that has a list of students enrolled in each class. You will create a student table and subform, a junction table to hold a many-to-many relationship with the class table, and a combo box on that student form to select each student. Plus the Extended Cut shows how all of the initial tables and forms were built from scratch.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today! LinksSubform in a Continuous Form: https://599cd.com/SubformInContForm
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||
Keywords: TechHelp Access Multiple Nested Continuous Subforms microsoft access subform ms access subform ms access multiple subforms example ms access filter subform ms access create subform ms access continuous form with subform PermaLink Nested Continuous Subforms in Microsoft Access |