Supress printing subreport

[jrabenhorst]

Hey everyone...

I have a report I've created with a sub-report built into it, but I only want the subreport to print if I have a check box checked within the main report. How can I go about doing this? Thanks.

 

[Remou]

Perhaps:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If FlagFieldName Then
    Me.[Subreport Control Name].Visible = True
Else
    Me.[Subreport Control Name].Visible = False
End If

End Sub