You could do something like:

If CurrentProject.AllReports("YourReportName").IsLoad ed = True Then
'If you are here, the report is currently open
End If
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"Sue" wrote:

Hi all

I want to check if a report is open before running a bit of code on another
report, is there a command to easily check for this?

Thanks, Sue


.