This should work for the newer versions of Access ...
If IsLoaded("MyForm") then
<your code>
End if
Function IsLoaded(MyFormName) As Boolean
' Accepts: a form name
' Purpose: determines if a form is loaded
' Returns: True if specified the form is loaded;
' False if the specified form is not loaded.
If CurrentProject.AllForms(MyFormName).IsLoaded Then
IsLoaded = True
Exit Function
End If
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.