A Tabbed Access Form with Subforms and Sub-Sub-Forms

[@inspectorgadget4703]

I found this video more helpful than most on this subject. I finally learned how to bind my forms to a tabbed sheet. Vielen Danke Doktor Verschuuren.

[@franklinnutter]

This video is exactly what I was looking for. Thank you for making it!

[@hiikkis]

Thank you!Haven't used access in 10 years and I'm rusty. You explained my problem on spot! I dreaded that I have to use trial and errors couple days...

[@richiegreen]

This helped me realize that part of the "magic" is that the Order Detail Table is a Join Table with 2 foreign keys but no primary key.

[@razak8528]

"Shub-Form". Your accent is awesome!

[@alirizvi748]

Great video Dr. Gerard. You are showing queries with multiple tables in it for subforms. I don't think you are using that query as your control source, because if you did you won't be able to add or edit data. If you can make another video with focus on subform, sub-subform it will be appreciated.

[@bhatkiran7]

Thank you. Its the best way explained.

[@DwayneDeveaux1204]

Thank YOu sir, was very easy to follow.

[@montemorgan3237]

Simple and it works! Thank you for sharing.

[@moyomartin4501]

thanx buh i would like to know how to auto populate the fields by selecting the value in the lookup field

[@wendelbas]

Hi, @6.16 you can choose how to connect the sub forms. However, I do not get the field to choose, my sub form will be placed. Thus without the connection. What do I do wrong?

[@falahjomor]

Great doing, Thank you very much Dr. I usually gather all (forms and subforms) in one form, then link them. For the main form with first subform i linke them using wizard, however, for the first and the second subforms, i link them using unbound text box. Again, i would ask you to show us some videos about how to make report for multiple forms as in such case. many thanks Dr

[@ashrafzainaldeen9874]

hi, i want to design filter system : 2 males and 3 females from village number 2 and 1male and 2 females from village 6 , the result shown on one subform ; the idea is how i can join two functions criteria togather.

[@jjstccean]

Brilliant! Thank you.

[@mmgbtv]

ok I got lost. So first I have to creat the forms, then I use thise forms to create the subform queries. Then I use the subform queries to create my tabbed form?

[@A1mcNetDalePoston]

Hi Dr. Verschuuren! About 10 years ago I had designed several complicated Access Databases for a few different clients. After another 10 years of other work (PC repair, web design, networking, virus removal, etc.) I have decided to create a new custom database for my own business, a1mc.net. I seem to have forgotten some of the important secrets to great design I learned earlier the hard way (many, many hours of testing and design work). And now, HOLA, I found your video. I am so happy to have all of the important secrets recapped in one short video. You are truly an admirable Genius and God Bless you. If I can ever help you in anyway please call on me. Thanks again!

[@dr.gerardverschuuren9261]

Thanks for your kind words. If you would be ever willing to write a nice review for Amazon on one of my CDRom's, I would be very grateful: www.amazon.com/dp/1932802037. Thanks a lot.

[@rcerdayt]

Dr. Verschuuren Hi from Chile !!. I would like to ask you something that seems easy to do but in practice is taken me a little bit more than I wanted. How would you select a record from a record list, to show on a separate form with all of its fields ?. I have tried a few things, but access is moody and it works partially or not at all. I would really appreciate your answer.

[@JustmeJoy7]

Thanks for sharing! I will check out the website to see how many hours of training your course is and to find out more info. Thanks again! I am assuming when I finish with the course, I will be an Access Expert :-)

[@stephaniescolman778]

Hi. I'm having a hard time getting my subform to only view the items for that customer. I have tried to make a relationship between the IDs and nothing is working. Can I email you for help?

[@MsHasan76]

Hello Dr.Gerard please where i can find the sample database

[@chrisanga]

can you enplane me to make Order form that you are showing.

[@Dr_G.S.Vlachos]

Amazing! Thank you!

[@cwstiles37]

In the first form that you made, without the tabs, you have a subform for the department that does not have the outside bars and looks more like it is part of the main form. How do you do that?

[@krishnadeoyadav6210]

happy birthday

[@hosszu2010]

Dear Sir, This is a very nice video, thank you for uploading it, great clear instructions. Do you know if with this method one can also add a new record (so in your example a new employee) instead of modifying old ones? Thank you

[@hoganliu1636]

so great!!!

[@Cupids-lx5xj]

cant select my subform if my ID was not insert.. need help

[@elsadatmohamedable]

thank you very very much

[@romeowhiskey1146]

CD isn't AVAILABLE....

[@A1mcNetDalePoston]

May I have your permission to link your video inside my website under tutorial videos as an ad for you? I personally have no incentive to teach access myself but maybe PC maintenance and/or Word press web design.

[@dr.gerardverschuuren9261]

DalePoston Sure!

[@trajkomiki]

Тo create Orders Subform Query you put OrderID from Orders Table. Why aren't you putting OrderID from Order Detail Table? May I put OrderID from Order Detail Table instead of OrderID from Orders Table? By the way, great tutorial.

[@dr.gerardverschuuren9261]

Miroslav Andreevski You always have to use the ID on the "many-side", otherwise you cannot at new records to the subforms.

[@grtraders]

Great Tutorial!! Dr Gerard, what software are you using to record your Videos? It is pretty neat ;)

[@dr.gerardverschuuren9261]

Camtasia Studio

[@grtraders]

Thanks.