Determine if form is open in Access 2002

[ray]

Hello All,

How do you determine if a form is open?

Thanks in advance.
Ray

 

[Allen Browne]

How do you determine if a form is open?

In Access 2002, you can use:
If CurrentProject.AllForms("MyForm").IsLoaded Then

 

[GreySky]

In other versions:

If syscmd(acsyscmdgetobjectstate, acform, "frmYourForm")
<> 0 Then

' it's open (could be design mode, but it's open)

end if


David Atkins, MCP