#Error when report has no data

[tylerg11]

Hello,



I have a function on my main report that totals multiple different textbox values. This works great with the exception that one of these text boxes exists on the subreport. As long as the subreport contains data this is not an issue. However, when the subreport doesn't return records, the final total shows up as #Error.

I read online that I can use the HasData function to detect for records and return a 0 if non are returned. I am still getting an error.

=IIF([SubReportName].Report.HasData=True, [SubReportName].Report![SubReportFieldName, 0)

[pbaldy]

You're missing a closing bracket there. I use this:

http://access.mvps.org/access/forms/frm0022.htm