Check if form is open

[RobM76]

Hi there,

Can someone please tell me how to check if a form is open??

thanks....

 

[Andrzejek]

    Dim frmMyForm As Form

    For Each frmMyForm In Forms
        If frmMyForm.Name = "Form1" Then
            MsgBox "Bingo!"
        End If
    Next frmMyForm

Have fun.

---- Andy

 

[RobM76]

Thats great.

Thanks Andrzejek!!!!!!!!!!!!!

 

[strongm]

Um ... that just tells you if the form is loaded, not if it is open ...