Routine Details: Building a Third Synchronized Subform in Microsoft Access - Fitness 75

In this lesson, we continue building our Microsoft Access Fitness Database by adding a third synchronized subform for routine details, making it easier to automatically display related information as you move between records. I will show you how to update the menu, create and link the new subform, and ensure synchronization across all forms. We will also walk through creating a combo box that combines exercise groups and exercise names, using a custom query, so you can select exercises more easily and display descriptive information. Next time, we will discuss adding custom sort order tools for rearranging exercises within routines. CHAPTERS: 00:00 Introduction 01:08 Adding Programs and Routines to the Menu 02:35 Adding the Routine Details Subform 03:16 Editing the Routine Detail Form 04:53 Synchronizing the Third Subform 05:23 Testing Subform Synchronization 06:34 Creating the Exercise Combo Box 07:31 Building a Query for Group and Exercise Names 09:10 Adding the Combo Box to the Form 10:39 Customizing the Combo Box and Layout 12:31 Conclusion BECOME A MEMBER: YouTube:    / @599cd   or My Site: https://599cd.com/THMember LEARN MORE: Fitness 75: https://599cd.com/Fitness75 PREREQUISITES: Fitness, Part 74: https://599cd.com/Fitness74 UP NEXT: Fitness, Part 76: https://599cd.com/Fitness76 RECOMMENDED COURSES: Access Developer Courses: https://599cd.com/Developer FREE TEMPLATE DOWNLOADS: TechHelp Free Templates: https://599cd.com/THFree Blank Template: https://599cd.com/Blank Contact Management: https://599cd.com/Contacts Order Entry & Invoicing: https://599cd.com/Invoicing More Access Templates: https://599cd.com/AccessTemplates DIAMOND SPONSORS: More info on our Sponsors: https://599cd.com/DiamondSponsors ADDITIONAL RESOURCES: FREE Access Beginner Level 1: https://599cd.com/Free1 How to Use Access in 30 Minutes: https://599cd.com/30Minutes $1 Access Level 2: https://599cd.com/1Dollar Donate to my Tip Jar: https://599cd.com/TipJar Merch Store! Get your swag here: https://599cd.com/Merch Get on my Mailing List: https://599cd.com/YTML Contact Me: https://599cd.com/Contact TechHelp: https://599cd.com/TechHelp Consulting Help: https://599cd.com/DevNet Twitter:   / learningaccess   https://en.wikipedia.org/wiki/Microso... https://products.office.com/en-us/access https://microsoft.com/en-us/microsoft... KEYWORDS: TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, programs and routines form, synchronized subform, routine details, subform synchronization, combo box exercises, group exercise query, menu editor, sort order, rearrange records, forms navigation, parent child forms, exercises table, muscle groups, bound fields, custom sort buttons QUESTIONS: Please feel free to post your questions or comments below. Thanks. Live long, and prosper.