! How Do I Check Form is Opened !

Wembly · Sep 10, 2003

Hi,

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

Thanks for your help.

Wembly

Albert D. Kallal · Sep 10, 2003

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 · Sep 10, 2003

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 · Sep 10, 2003

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 · Sep 12, 2003

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