How to Use Form and Subform Variables in Microsoft Access

[@interestingamerican3100]

Commenting for the algorithm. Love the content! I learn every time I watch.

[@seanmackenziedataengineering]

Awesome! Thank you!

[@pwestphotography]

Make so much sense when it is well presented - love the videos

[@seanmackenziedataengineering]

Thanks Paul!

[@rogerio74c]

Wow! Fantastic! Love to know that! Access doesnt stop to surprise me.

[@seanmackenziedataengineering]

Glad it helped! Cheers

[@EstoYOtro]

Certainly a way to go. IF. If the line 'Set frm = Forms(strForm)' would work (4:20). On all my machines, it produces Error 438, Object doesn't support this property or Method. And yes, I used exactly your code. Any idea?

[@seanmackenziedataengineering]

In the code, when you go Tools > References, what entries are checked off there?

[@EstoYOtro]

Sean, thanks for coming back to my problem. I thought about the references as well, but I found the error, and it's absolutely weird: The form I put the code into had a tab-control. Once I deleted that, all was working fine. Go figure...@@seanmackenziedataengineering

[@jim27105]

I would like to use a subform to display various forms, which the user can run a query from. In other words the subform ‘window’ would just display form 1, form 2, form 3. It seems like it would be easy to do but all the videos i find are for data entry, not navigation. Any suggestions or perhaps a future tutorial?

[@seanmackenziedataengineering]

Interesting idea. You may be able to change the control source for the subform control in order to switch the subform viewed. As an alternative, you may want to use the tab control, then put different subforms on each tab. You can control which tab is shown, based on some criteria on the parent form.

[@ibrahimalrabiah1179]

Nice, but I have figured a problem it works once for me . After a while ( Dim as Form ) stopped working , so I replaced all controls to Full original bath FORMS!Mainform!CboResult , like that and it works again , is there any solution to find what stopped the Dim FORM FROM WORKING , THANKS

[@seanmackenziedataengineering]

Interesting! Yes, if you have frm as Form A, referring to another open form B, but that form B is closed (and reopened), the reference in form A will break. This is also true if you refer to forms from a Sub or Function in a module.

[@jerrydfowler3480]

Sean could this be used to open a form and give it a certain Record Source? I have a form that I could use with multiple queries. One is just for members that have emails and one is for those that don't or rather get item per the mail. So when I choose one button I would like it to open the form and give it the email records, or I choose another button and open the same form but with records without emails or prefer mail. Thanks for you top notch videos

[@seanmackenziedataengineering]

Great question. Indeed, you can swap out the Record Source at runtime in order to change the records you are working with. When doing this exercise, you can check out the properties when you type frm. The dot after frm will let you see different properties. One of them is Record Source. Put in an alternate SQL statement and it will switch the view. Alternatively, if the different views are all from the same table, you can set the form filters instead. Like this video: kzbin.info/www/bejne/q6KWlJqXfatpnMU

[@dbdata9836]

thankssss

[@seanmackenziedataengineering]

You’re welcome!

[@dbdata9836]

10/10

[@seanmackenziedataengineering]

Thanks!

[@dbdata9836]

great

[@seanmackenziedataengineering]

Thx!

[@alikayn]

Your content is good, but seriously, your laconic delivery meant that I kept having to stop the video and do anything else because it was boring to wait (pause) for (pause) each (pause) and (pause) every (pause) word. Can't you be a bit more enthusiastic and pacey? Faster delivery gets the message into the brains of the audience more effectively (see Accelerated Learning techniques). Repeating an idea is better, restating an idea, but just dragging it out suggests that you know it's boring, but don't respect the time and intelligence of your audience.