Check if a report is open in VB

  • Thread starter Thread starter Max Moor
  • Start date Start date
M

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
 
In the latest versions, you can use:
CurrentProject().AllReports("MyReport").IsLoaded

For earlier versions:
SysCmd(acSysCmdGetObjectState, acReport, "MyReport")
 
In the latest versions, you can use:
CurrentProject().AllReports("MyReport").IsLoaded

For earlier versions:
SysCmd(acSysCmdGetObjectState, acReport, "MyReport")
Click to expand...

Thanks, Allen. Works like a charm.
- Max
 
Back
Top