Check if a report is open in VB

[Max Moor]

Hi All,
What is the simple way to check, from VB, if a particular report is
already open? I'm just not finding it in the help.

Thanks, Max

 

[Allen Browne]

In the latest versions, you can use:
CurrentProject().AllReports("MyReport").IsLoaded

For earlier versions:
SysCmd(acSysCmdGetObjectState, acReport, "MyReport")

 

[Max Moor]

In the latest versions, you can use:
CurrentProject().AllReports("MyReport").IsLoaded

For earlier versions:
SysCmd(acSysCmdGetObjectState, acReport, "MyReport")

Thanks, Allen. Works like a charm.
- Max