How to Create Multiple Nested Continuous Subforms in Microsoft Access
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?
LINKS:
Subform in a Continuous Form: [ Ссылка ]
Many to Many: [ Ссылка ]
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to a 37-minute long EXTENDED CUT of this video which covers additional examples. That video will 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.
MEMBERS ONLY VIDEO:
[ Ссылка ]
BECOME A MEMBER:
[ Ссылка ]
or [ Ссылка ]
ADDITIONAL RESOURCES:
FREE Access Level 1: [ Ссылка ]
FREE Customer Template Database: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
Your Questions Answered: [ Ссылка ]
Learning Connection 50% OFF: [ Ссылка ]
Survey: [ Ссылка ]
Richard's Blog: [ Ссылка ]
Access Forum: [ Ссылка ]
Twitter: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
Email Me: amicron@gmail.com
KEYWORDS
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
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
