Detective a Forms Status Opened/Closed

[Guest]

How can I detect, programatically, if a form is opened or closed?

Thanks

Ross

 

[Allen Browne]

In Access 2000 and later, you can use:
CurrentProject.AllForms("Form1").IsLoaded

In earlier versions, use:
SysCmd(acSysCmdGetObjectState, acform, "Form1")
If that seems a bit cryptic, copy the IsLoaded() function from the Northwind
sample database. It's a wrapper for the SysCmd() call.

 

[Guest]

Thank You Allen

In Access 2000 and later, you can use:
CurrentProject.AllForms("Form1").IsLoaded

In earlier versions, use:
SysCmd(acSysCmdGetObjectState, acform, "Form1")
If that seems a bit cryptic, copy the IsLoaded() function from the Northwind
sample database. It's a wrapper for the SysCmd() call.