Form Status (Open)

[Jefftopia]

I would like my code to execute a msgbox if a certain form is open. Is there some kind of Boolean that will tell me if a form is currently open?

 

[GJParker]

For Each Form In Forms
If Form.Name = "FormName" Then
MsgBox Form.Name & " is open", vbOKOnly
End If
Next Form

Forms is standard VB colllection of open forms Gary Parker
Systems Support Analyst

 

[M626]

on form load

put

Private sub Form_Load
msgbox " what ever you message is"
end sub

 

[Jefftopia]

thnks GJParker.

exactly what i was looking for

 

[strongm]

Be careful. The forms collection contains all loaded forms, but a loaded form is not necessarily visible/open.

 

[Jefftopia]

strongm,

thanks,,point taken