If subreport has no data, do not show text
Posted on 2014-02-06
I have a second page on an Access report that I do not want shown if there is no data in the subreport that makes up that second page. My subreport does not appear if it is empy so I'd like the text above it to also not appear. I'd really not even like a second page, if possible.
My subreport is tblContractAiringDatesSubreport.
The text I"m trying to hide is Text165.
I cannot get the syntax to work:
Private Sub tblContractAiringDateSubreport_Enter()
If Me.Report.HasData Then
Me.Text165.Visible = True
Me.Text165.Visible = False
I'm not even sure if this is where I should be putting the If statement.
But also not sure the subreport is being reference correctly.
Thanks in advance for any help.