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

[@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.

[@petewarby7158]

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.

[@petewarby7158]

Love your commentary, educational and amusing. Perfect combo :) Thanks for the video. Really useful as always.

[@599CD]

You're very welcome.

[@marksimonian210]

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

[@599CD]

Thanks I appreciate that

[@mloucel7]

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

[@heyjude1971]

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!

[@599CD]

It's coming. Just ask Adam.

[@tonyleethal]

This channel is the bomb!!! I love it

[@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.

[@599CD]

Nice work

[@niktsol]

@@599CD Thanks s lot. I appreciate your answer as well as the nice videos you share.

[@lawrenceayanful6204]

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

[@599CD]

I appreciate that thank you very much

[@ijo680]

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

[@599CD]

Sweet!

[@evanmorgan5374]

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?

[@599CD]

The same trick doesn't work? Did you 599cd.com/TryIt?

[@westonreed545]

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?

[@599CD]

599cd.com/ask

[@rogerstrate5727]

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.

[@599CD]

Oh... I remember when I was first learning Access and how many hours I wasted on things...

[@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: =[StarshipF].[Form]![StarshipID]. 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

[@599CD]

If you've got spaces in your field or table names, you need the brackets.

[@eyjavi]

Super cool, super useful!! thanks

[@599CD]

You're welcome!

[@stephenbeswick2163]

Hi Richard another great video great thanks Richard. 😊

[@599CD]

Welcome

[@PeterVendelbo]

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

[@NimishP]

Great tip. Thanks!!!!

[@599CD]

Yep!

[@luzkrg]

Awesome, thank you!!! 🤩🤩🤩

[@599CD]

Welcome

[@akokohjoel9854]

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 ?

[@robertodc62]

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

[@599CD]

Glad you like them!

[@drcl7429]

Just implemented this exact type of scenario yesterday in a custom inventory system but used code then this video appears today. Algorithms be scary. Would have saved me some time if it had come up 24 hours ago. Going to see how much code I can remove using this way. Whenever I try using master-Child in the past it doesn't work properly so I have given up trying to use that anywhere. Maybe it can be redeemed. Pretty sure an alternative way is to use a filter property based on the textbox in the master form though and still slash a lot of code.

[@Tigist45]

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?

[@txmmoore]

Great teacher. However, how do you approach a two page form? That is, you have a form in which you are entering a ton of data and you want to break it up into two separate forms? Aka, page 1 and a page 2?

[@599CD]

599cd.com/QQ

[@zmareyshahi]

informative as always

[@599CD]

Glad you liked it

[@doctorchinmoy]

Awesome... You are superb

[@599CD]

Thank you! Cheers!

[@shahabshahramfar1352]

Hello dear Richard, I've written a program consisting of three tables: Seller, Sender, and Phone, which are related to each other in a one-to-many relationship. Currently, according to the program, there are multiple phones for each sender, which I've implemented and it works well. However, I don't know how to create the relationship between Seller and these two tables to indicate that each seller has multiple senders, and each sender has multiple phone numbers. If possible, please guide me. Thank you.

[@nicholaitunstall7031]

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?

[@txmmoore]

The issue I have with this, is you have 1 form with two sub-forms imbedded into the main form. The problem I have is I want only page 1 (subform#1) to be visible and enter data. Then when ready, click a button and have Page#2 (Subform#2) appear to enter additional data. Then switch back to Page #1, if necessary. Is this possible?

[@mloucel7]

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

[@vsisouphone]

How to requery to different database listbox?

[@acleary1]

I have a cross tab query that I want to show the results in the other sub form but when I try to do your link trick with the text box I get a ?Name? error.

[@599CD]

Hmmm... need more info. Post in the Forums with some screen shots: 599cd.com/AF

[@acleary1]

Done and thank you for the response

[@ahsanzaman-668]

Hi Richard! When I try and follow the same steps, Access gives me an error saying "Can't build a link between unbound forms". Any suggestions?

[@erikamartinezhernandez9855]

I have the same. :( but I follow the same steps in another form and it works.

[@599CD]

Never seen that one before. Post some screen shots. 599cd.com/ASK

[@ssdusd]

Loved it

[@599CD]

Thanks

[@muhammadimranrafique4778]

thank you sir ,how to manage in school student family sibling data .

[@599CD]

I get a ton of questions every day, and I don't have time to answer them all here on KZbin. Feel free to submit your question on my website at: 599cd.com/AskYT

[@rufinojr54]

Nice! My question is, I have an unbound mainform with 2 subforms, both subforms are from the same recordsource. How can I open another form using a button, when I select a record either from the 2 subforms?

[@599CD]

Just issue an OpenForm command based on whatever value you want, like: DoCmd.OpenForm "FormF",,,"WhateverID=" & SubformName.Form!FieldName Open Form: 599cd.com/OpenFormSpecific

[@AustinLovesDrPepper1]

I'm not sure if this is how this works, but if I have an employee assigned to a specific task and that task is "active", and I have a subform stating what their status is based on if they're on that task, how do I update their status on the subform to "busy" whenever I assign them to that task?

[@599CD]

I'd need to know more. Post some screen shots and details in the Forum: 599cd.com/AF

[@silentlover771]

I have querry... I have a part number list with master number and optional copy part numbers so i need when i search master part number its should show me copy part number as well... Please help me to make this querry

[@599CD]

I get a ton of questions every day, and I don't have time to answer them all here on KZbin. Feel free to submit your question on my website at: 599cd.com/AskYT