Subreport On No Data event

[lmcc via AccessMonster.com]

I have a report with a subreport. Sometimes the subreport has data and
sometimes it does not.

If the subreport has no data, I want the lblAdditionalAddresses label to not
be visible. In the subreport On No Data even I entered the following code:

Reports![rptCompanyProfile]![lblAdditionalAddresses].Visible =
False

It is not working.

How can I get this to work?

Thanks.

 

[Allen Browne]

Right-click the lblAdditionalAddresses, and Change To | Text Box.

Set its Control Source property to:
=IIf([Sub1].[Report].[HasData], "Addresses:", Null)
substituting the name of your subreport for Sub1.

 

[lmcc via AccessMonster.com]

Thanks, that did it!

Right-click the lblAdditionalAddresses, and Change To | Text Box.

Set its Control Source property to:
=IIf([Sub1].[Report].[HasData], "Addresses:", Null)
substituting the name of your subreport for Sub1.

I have a report with a subreport. Sometimes the subreport has data and
sometimes it does not.

[quoted text clipped - 6 lines]

Reports![rptCompanyProfile]![lblAdditionalAddresses].Visible =
False