(Q) How do I find out from code if a form is open or not?
(A) Pass the form name to the following function. Function will return True if
form is open and False if it's not.
Function fIsLoaded(ByVal strFormName As String) As Integer
If SysCmd(acSysCmdGetObjectState, acForm, strFormName) <> 0 Then
If Forms(strFormName).CurrentView <> 0 Then
fIsLoaded = True