Preview shows data, Printed Report shows #Error

[Guest]

Hello,

I have a report with calculated fields using Dlookup, DCount and DSum
statements.
The report looks great in preview mode but when I print the report, each
field except for labels has #Error within it.

I'm using a form (combobox) to pass the variable which uses the query for
all the calculated fields in the report. Does the print lose the variable
value of query or something?

 

[fredg]

Hello,

I have a report with calculated fields using Dlookup, DCount and DSum
statements.
The report looks great in preview mode but when I print the report, each
field except for labels has #Error within it.

I'm using a form (combobox) to pass the variable which uses the query for
all the calculated fields in the report. Does the print lose the variable
value of query or something?

You may be closing the form before the report is printed.
Make sure there is no code in the report or elsewhere (except in the
report close event), that closes the form.

 

[Guest]

Hello Fred,

I had the call in my macro to close the form which passes the variable for
the query.
You were correct.

Thanks,
Rocky