Subforms are a great way to both display related child data, and allow users to work on child data related to a parent record in another form. In this example, we’ll create an orders form, and then put the line items for that order in an order items subform. When we scroll through the orders, the child list on the subform also changes. This tool is a critical one for your Access toolkit! Related Videos: 2 Ways to Create Command Buttons on MS Access Forms https://www.youtube.com/watch?v=RG2wyc1Bmtg How to Make a Listbox in MS Access Part 1: Single-selection https://www.youtube.com/watch?v=zP05W0BWdi8 How to Create a Multi-Column Combo Box in MS Access, Adjust the Width and Bind it to the Table https://www.youtube.com/watch?v=8KtsHb5Imu8 How to Use Form and Subform Variables in Microsoft Access https://www.youtube.com/watch?v=k9xkhc8GvKo How to Retrieve Any Column Value from a Combo Box or List Box in Microsoft Access https://www.youtube.com/watch?v=7s2xdpFpYwk How to Create a Subform in MS Access You are watching this video now! How to Use the Tab Control in Access: Tabs with Subforms Example https://www.youtube.com/watch?v=ZFs00ebEh4Q MS Access Option Groups - How to Use Radio Buttons https://www.youtube.com/watch?v=eg4RUEsPPiw How to Use Reference Expressions to Get Form Values in MS Access https://www.youtube.com/watch?v=I2JU95lnz_w How to Use Nz in Microsoft Access to Handle Null and Empty Values https://www.youtube.com/watch?v=CR3FmVoRFys After Update on Form Controls in Microsoft Access https://www.youtube.com/watch?v=stQhrFY4k8E Want to work with me 1:1? Contact me today and book your free 20 min consultation! Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering #MSAccess #Subform https://www.youtube.com/watch?v=tQfAol75j_I