If CurrentProject.AllForms("YourFormNameHere").IsLoaded Then
'it's open
Else
'it's not
End If
There's an example in the Northwind sample database that also checks to see
whether the form is open in Design View. Look for the IsLoaded function in
the Utility Functions module.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.