Check that My Form is not Closed

[Ossos]

Please, what is wrong with this if statement

If [0_Haram's Healthcare Dashboard N].IsLoaded = False Then
MsgBox "No Previous Screen The Screen 11 is Closed"



Else
Forms![0_Haram's Healthcare Dashboard N].Visible = False

End If

i am keep receiving Run-Time error 2465
MS Access can't find the field '|1' referred to in your expression.

[ItsMe]

Maybe
Forms![0_Haram's Healthcare Dashboard N].IsLoaded

[Ossos]

i changed it to

If [0_Haram's Healthcare Dashboard N].IsLoaded Then
Forms![0_Haram's Healthcare Dashboard N].Visible = False

Else

MsgBox "No Previous Screen The Screen 11 is Closed"
End If

still relieve the same error

[Ossos]

I even used "IF Not"

If Not [0_Haram's Healthcare Dashboard N].IsLoaded Then
Forms![0_Haram's Healthcare Dashboard N].Visible = False

Else

MsgBox "No Previous Screen The Screen 11 is Closed"
End If


I got the same Error

[ItsMe]

Let me look at my notes and see how I have done it in the past.

[ItsMe]

Here, I tested this.

Dim bolAnswer As Boolean
Dim strFormName As String
'strFormName = Me.Name
strFormName = "OtherFormName"
bolAnswer = (SysCmd(acSysCmdGetObjectState, acForm, strFormName) <> 0)
    If bolAnswer = True Then
        MsgBox strFormName & " is open"
    Else
        MsgBox strFormName & " is closed"
    End If

[jwhite]

For the record:

If CurrentProject.AllForms("0_Haram's Healthcare Dashboard N").IsLoaded = False Then
    MsgBox "No Previous Screen The Screen 11 is Closed"
Else
    Forms![0_Haram's Healthcare Dashboard N].Visible = False
End If

[Ossos]

It works ... :-)

Thank you All, Please jwhite would you please explain to me the logic behind it?

Regards

[ItsMe]

Yeah jwhite, what does your code do, exactly?