W
Wembly
Hi,
How would I write the code to check whether a form is
opened or not?
Thanks for your help.
Wembly
How would I write the code to check whether a form is
opened or not?
Thanks for your help.
Wembly
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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
However, the follwing is quite good:
http://www.mvps.org/access/forms/frm0002.htm
M
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
For Each abc In Forms
If abc.name = "Form2" Then MsgBox "Form2 is already open"
Next
May
MCP in Access and SQL Server
D
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
Dim abc As Form
For Each abc In Forms
If abc.name = "Form2" Then
MsgBox "Form2 is already open"
Exit For
End If
Next
A
Alejandro Semo
En [email protected] del 10/9/03 07:49, "May"