#error in every control

[Ray]

I'm running a report and I get #error coming out in every
control on the report.
What does this mean and how do I fix it?
I cant run my query manually since it needs input from
forms so there is no way to tell what the query is
returning.

 

[Jeff Boyce]

Ray

I don't understand. Are you saying you can open the necessary forms, set
the fields as needed, then open the database window and run the query?

OK, can you simply open the query in design mode and "hard-code" values in
that the query would get from forms? Does this return the values you need
for your report?

Can you open the report in design mode and confirm that it uses the correct
query as its source?

Good luck

Jeff Boyce
<Access MVP>