previous report appearance

[Alex]

When I'm opening a report for different dates and if I
didn't close the previous one it would appear the same
previous report (not a new one).

How could I check whether the previously opened report was
closed or how to open a new one in a separate window?

Thanks,

Alex

 

[Jim/Chris]

If SysCmd(acSysCmdGetObjectState, acReport, "nameofreprot)

0 Then

MsgBox :report is already open"
Else
DoCmd.OpenReport . . .
End If

Jim

 

[Alex]

Thanks a lot.

-----Original Message-----
If SysCmd(acSysCmdGetObjectState, acReport, "nameofreprot)

MsgBox :report is already open"
Else
DoCmd.OpenReport . . .
End If

Jim
.