How to Synchronize Multiple Related Subforms in Microsoft Access Without Any VBA Programming

In this video, I'm going to show you how to use two subforms to browse related records using an intermediary parent form. This will allow you to see a set of parent records in one subform, you can click on one, and then see the list of related child records in the second subform. For example, we'll see a list of starships and their crew. The same concept works for categories and products, customers and orders, employees and timecards, etc.

LEARN MORE:

PRE-REQUISITES:

RECOMMENDED COURSE:

LINKS:

BECOME A MEMBER:

ADDITIONAL RESOURCES:

KEYWORDS
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, Synchronize Two Related Subforms, How to Link Two Subforms, Multiple Subforms, Synchronizing Multiple Subforms, Synchronizing Two Subforms, link subforms, ms access multiple subforms example, access link subforms

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[DingusBatus]

I'm a bit of a Star Trek, and Sci-Fi, nerd myself.
I have basic MS Access skills and looking to improve on them. I've seen a few of your videos now and I really like your style. Good pacing, good narrations, and good humor too.
Also the way you contextual drop in mentions (advertise) your other videos is brilliant, and unique.

[petewarby]

Your knowledge is second to none and your teaching style is awesome. I can see you still really enjoy using the software, good on you :)

These are all videos that added helping me put a great thing together for my wife. So satisfying to have something before rather than paying someone to create it and hoping they do what we need.

[mloucel]

You just solved my problem between specialty and their Dr/specialties issue, boy oh boy, this is GENIUS level..

[marksimonian]

Your channel is my go to when I want to refresh my memory about how to do something. Excellent and many thanks.

[ijo]

Great Fast Tip Richard, I sure learned something, as always

[heyjude]

Thanks Richard!
I was JUST getting ready to implement this as an employee - TO - timesheet interface - impeccable timing!
Unrelated: Would love to see a TempVars video sometime!

[stephenbeswick]

Hi Richard another great video great thanks Richard. 😊

[niktsol]

Very nice video. My approach was to create a main form which includes 2 subforms. The first (left subform) will be the main menu form (i.e. 1. Customers, 2 Orders, 3. Admin Screen, etc) and the subform at the right will be actually a container in which each form according to the choice on the left, will be loaded. This video helped me a lot. Actually i wanna create my own "Navigation form" style, for older Access versions when Navigation forms was not available.

[MiguelRamosLIve]

Thanks! Great video and great channel.
14:09 For some reason (Different version?) my Access mandates that I include the square brackets in the syntax as:
Also
I called my "Master ID" differently from the one used in the Child Form. No problem: Just use the corresponding names in the All / Link Master Fields and All / Link Child Fields and it is A-Ok

[lawrenceayanful]

I like how you make boring geeky stuff spicy with your Dracula voice and stuff... 😂.. Really entertaining...

[rogerstrate]

I love this fast tip, I am beginning to catch on as it only took me 2 tries to get it right. (You don't want to know how many hours it took.) ha ha.

[evanmorgan]

Hey Richard - thanks for all the vids! I watch all the time. Any chance you have a way to synchronize 3 subforms within 1 master form?

[robertodc]

lol so you are a treky as i, you are great richard i love your videos

[PeterVendelbo]

Alternating color; you could also set it to 'No Color' under the 'Format' menu 'Alternative Row Colour'

[akokohjoel]

Mr rost, thanks for your video. Pls from the video how can one update data from one subform to another subform.
That's a value in subform A can move to subform B. What vba code will do that by clicking or double clicking ?

[westonreed]

Richard thank you for all these videos! I'm very happy with being able to have 2 synchronized list forms next to eachother. I do have a question for you though...I tried putting the VBA code I learned from you that opens a form to the last record put in and it works when I open the forms individually but not when I open the form where they are side by side subforms. Is there a way to open them to the last record in this circumstance?

[nicholaitunstall]

I want a form for users where there's a userlist and clicking on the record updates the textboxes displayed to directly edit the user but not using a splitform. I have no idea how to do this as having a subform without master child fields shows all the users, but the textboxes aren't then linked to the subform selection. Help?

[viengxaysisouphone]

How to requery to different database listbox?

[mloucel]

Question: How can I use the same Form to ADD a new " Starship " and then ADD the Crew?

[RamatsiyonMesfin]

Hi Richard
Can I synchronize three subforms of three tables(1 to many's) using link master fields and link child fields properties of subforms and are the fields editable?