#Error Message in Report

[Beth Eadie]

I have a form, query, and report that I am trying to get to work. The form
contains a combo box which lists many services that the user can choose from.
This calls the query, then opens the report and displays the information.
If I open just the report, I can get the information to populate. If I open
just the query, it works as well. But when I try opening from the form, I
get #Error on my report.

I believe I know why I am getting this message, I just don't know how to fix
it. There is one field on my report (Ethnic Description) that has no records
in the table, so it doesn't show on the report. Since this is a null value,
it would return the #Error, correct? How do I fix it so that it will show a
0 instead of nothing? I have attempted using an IIF statement and the Nz
function, but nothing is working.

I can provide code if need be.
Please help!
Thank you!

 

[Allen Browne]

See:
Avoid #Error in form/report with no records
at:
http://allenbrowne.com/RecordCountError.html