I think I'm having a major brain fade or something but I can't figure this out. I've seen plenty of people asking how to get rid of the extra space left on a main report when a subreport has no data. That I can handle!
What I want to do this time is retain the space on the main report and maybe include some placeholder message such as "No data entered yet" for each subreport that has no data.
I originally had no labels attached to my subreports but tried attaching one and added this code to the Detail_format of the Main report:
But this generates an error saying the subreport is not open or doesn't exist.
Any suggestions?
TIA
What I want to do this time is retain the space on the main report and maybe include some placeholder message such as "No data entered yet" for each subreport that has no data.
I originally had no labels attached to my subreports but tried attaching one and added this code to the Detail_format of the Main report:
Code:
If IsNull(Reports!SubReportName!SubReportKeyFieldName) Then
Me.SubReportLabel.Visible = True
Else
Me.SubReportLabel.Visible = False
End if
But this generates an error saying the subreport is not open or doesn't exist.
Any suggestions?
TIA