[AccessD] Refer Report Sub

How do you refer to a sub report? I do not want the subreport to show
records that do not have data. Right now, it still shows the headings
for the subreport, but there isn't any data, so I don't want it to show
the headings or the report if they are null.

 

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

   If
IsNull(Reports!rpt_FilterSpecial.Report.rpt_FilterSpecialSub.InventoryID
) Then

        Me.Report.rpt_FilterSpecialSub.Visible = False

    Else

        Me.Report.rpt_FilterSpecialSub.Visible = True

    End If

End Sub

 

Virginia