Dealing with headers for report that is Standalone and Sub-report

[mystuff]

I have a report that can be printed both as a stand-alone report, or as a subreport in another report.

I want the Report headers/footers and page headers/footers to print when it is being run by itself (standalone), but I don't want these headers to print when it is a subreport. How can I do this?

Thanks.

 

[dhookom]

No page sections or events or controls will display when the report is used as a subreport. If you want to hide a report header of a report only when used as a subreport, you can use code like:

Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)
    On Error Resume Next
    Cancel = Me.Parent.Name & "" > ""
End Sub

Duane
MS Access MVP
Find out how to get great answers faq219-2884.