Microsoft Access Fitness Database Part 17: Making a Subform in a Header Control the Parent Form

In this Microsoft Access tutorial I will show you how to create a subform in a form's header that controls the parent form, set up consistent form layouts, adjust background colors for clarity, use conditional formatting for field highlighting, and address issues with editing aggregate query results. This is part 17.

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
Fitness 17: https://599cd.com/Fitness17

PREREQUISITES:
Fitness, Part 16: https://599cd.com/Fitness16

UP NEXT:
Fitness, Part 18: https://599cd.com/Fitness18

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, fitness database, subform in header, continuous form subform, aggregate query, MealListQ, MealListF, filter parent form, master child fields, on current event, conditional formatting, field has focus, color coding forms, design view, add new button, scroll buttons

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.