How to Tell if a Form is Loaded (Open) in Access

In this Microsoft Access tutorial, I will show you how to determine whether a form is currently open (loaded) in Microsoft Access. We will use this to determine if a specific form is open so that if it is, we can update a value on it if needed.

Jeremy from Bethesda, Maryland (a Gold Member) asks: I have two forms in my database: one for a technician and another for the job that's assigned to him. On the technician form, I like to keep a count of how many jobs they have assigned. If I try to update this count from the job form and the technician form is closed, I get an error message. Is there any way to check if the technician form is open before I try to update that value?

Prerequisites

• Intro to VBA: https://599cd.com/IntroVBA
• Create Function: https://599cd.com/CreateFunction

Code Vault

• Is Form Loaded Code: https://599cd.com/IsLoadedCode - Normally reserved for Gold Members only!

Links

• DCount: https://599cd.com/DCount
• Nz: https://599cd.com/Nz
• Error Handling: https://599cd.com/ErrorHandling

Recommended Courses

• Access Developer Courses: https://599cd.com/Developer
• Custom Functions: https://599cd.com/acd2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

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, Is loaded, isloaded, is form loaded, isformloaded, isopen, isformopen, is form open, how to tell if a form is loaded, how to tell if a form is open, Check if Form is open, close one form if another is closed, run-time error 2450, cannot find the referenced form