Detect if a Form is opened

V

Vince

Hi,

I would like to find out if a form is loaded or not. In VB I do something
like:

Private Function IsLoaded(frmname As String) As Boolean
Dim item As Form
IsLoaded = False
For Each item In Forms
If item.Name = frmname Then
IsLoaded = True
Exit Function
End If
Next item
End Function

but I don't have a Form type in VBA. How to I modify this under VBA so that
it works?

TIA,
Vince
 
Top