Prev: Passing data to a Report
Next: Conditional Footers in a report
From: Beth Eadie on 9 Jul 2008 09:07
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!
From: Allen Browne on 9 Jul 2008 09:51
See:
Avoid #Error in form/report with no records
at:
http://allenbrowne.com/RecordCountError.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Beth Eadie" <BethEadie(a)discussions.microsoft.com> wrote in message
news:F18A5C07-4D0E-4F6D-96EE-A0AE4DD5CA54(a)microsoft.com...
>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!

 | 
Pages: 1
Prev: Passing data to a Report
Next: Conditional Footers in a report