Hiding a subreport

  • Thread starter Thread starter John Spencer (MVP)
  • Start date Start date
J

John Spencer (MVP)

Check the HasData property of the subreport's report control.

If Reports![rpt Employee Info_SS]![rpt Employee Info Sub].Report.HasData then
...
Else
...
End If
 
i'm tring hide/show a label on report if a subreport returns no records. i'm
doing in the on format event of the detail section.

i tried saying

If Reports![rpt Employee Info_SS]![rpt Employee Info Sub].Report!wageYear
Is Null Then


Report![rpt Employee Info_SS]![rpt Employee Info Sub]!Visible =
False

Access gave error on 1st line. How can i check the recordset count of a
subform?
 
Back
Top