In today's episode, we'll take a look at how to use form and subform variables in our Microsoft Access database. Using these two variables can make your code more reusable and easy to read compared to using other methods. We'll show how to open a form, set a variable to access its properties and methods. As an example, we'll set some text box values on a parent and subform as well as set the captions for more than one form using reusable code. Related Videos: 2 Ways to Create Command Buttons on MS Access Forms https://www.youtube.com/watch?v=RG2wyc1Bmtg How to Make a Listbox in MS Access Part 1: Single-selection https://www.youtube.com/watch?v=zP05W0BWdi8 How to Create a Multi-Column Combo Box in MS Access, Adjust the Width and Bind it to the Table https://www.youtube.com/watch?v=8KtsHb5Imu8 How to Use Form and Subform Variables in Microsoft Access You are watching this video now! How to Retrieve Any Column Value from a Combo Box or List Box in Microsoft Access https://www.youtube.com/watch?v=7s2xdpFpYwk How to Create a Subform in MS Access https://www.youtube.com/watch?v=tQfAol75j_I How to Use the Tab Control in Access: Tabs with Subforms Example https://www.youtube.com/watch?v=ZFs00ebEh4Q MS Access Option Groups - How to Use Radio Buttons https://www.youtube.com/watch?v=eg4RUEsPPiw How to Use Reference Expressions to Get Form Values in MS Access https://www.youtube.com/watch?v=I2JU95lnz_w How to Use Nz in Microsoft Access to Handle Null and Empty Values https://www.youtube.com/watch?v=CR3FmVoRFys After Update on Form Controls in Microsoft Access https://www.youtube.com/watch?v=stQhrFY4k8E For developers looking for a new role, check out and sign up: https://www.toptal.com/qKaO2b/worlds-top-talent Needing to hire technical resources for your project? Get the best: https://www.toptal.com/qKaO2b/worlds-top-talent Want to get access to premium content made just for you and have a chat with me? Find me on Patreon : https://www.patreon.com/mackenziedataengineering Demo of my BZ RDP Cloaker: https://www.patreon.com/posts/how-to-block-rdp-98471703?utm_medium=clipboard_copy&utm_source=copyLink&utm_campaign=postshare_creator&utm_content=join_link Want to work with me 1:1? Contact me today and book your free 20 min consultation! Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering #msaccess #vba