My Access Tips for Custom Microsoft Access
Application Development
by Matthew V Carmichael
Need Help?
My Tips
About
Quick Tips
Coding
Developing / Deploying
Errors
Functionality
User Interface
Downloads
Links
SaQus IT Solutions
UtterAccess
The Access Web
Resources
FMS, Inc
MS Access
VBA Reference
w3cSchools
Connection String
SQL Reference
Quick Tip Details
Question:
How can I determine if a form or report is open?
Answer:
You can use the Is Loaded property to determine if an Object is currently loaded.
Code:
Application.CurrentProject.AllForms("Your Form Name").IsLoaded