Hi,
Copy this Function and Pass the form name. If form is loaded and not shown, then it's Visible property will be false, u need to check that:
Private Sub CheckFormStatus(Myform As Form)
Dim objForm As Form
Dim FlgLoaded As Boolean
Dim FlgShown As Boolean
FlgLoaded = False
FlgShown = False
For Each objForm In VB.Forms
If (Trim(objForm.name) = Trim(Myform.name)) Then
FlgLoaded = True
If objForm.Visible Then
FlgShown = True
End If
Exit For
End If
Next
MsgBox "Load Status: " & FlgLoaded & vbCrLf & "Show Status:" & FlgShown
End Sub
Regards
Veena