! How Do I Check Form is Opened !

[Wembly]

Hi,

How would I write the code to check whether a form is
opened or not?

Thanks for your help.

Wembly

 

[Albert D. Kallal]

There is a number of ways to do this, and some depend on what version.

However, the follwing is quite good:

http://www.mvps.org/access/forms/frm0002.htm

 

[May]

Dim abc As Form
For Each abc In Forms
If abc.name = "Form2" Then MsgBox "Form2 is already open"
Next

May
MCP in Access and SQL Server

 

[Douglas J. Steele]

Or, slightly more efficiently,

Dim abc As Form
For Each abc In Forms
If abc.name = "Form2" Then
MsgBox "Form2 is already open"
Exit For
End If
Next

 

[Alejandro Semo]

En [email protected] del 10/9/03 07:49, "May"