Avoid re-queries when printing report

[Peter Irwin]

Hi newsgroup,

I have a report in Access 2K which relies on a query. The query itself
contains lots of fields which rely on VBA functions I wrote. Now to the
problem:

When I open the report in preview, the data on that report is OK. When I
print the report, it is as if the query was re-queried, i.e. the
functions are all executed again and so the data doesn't correspond
anymore.

Is there a way to tell the report to open the query as "snapshot", i.e.
making it "as is" for the print?

Thanks,
Peter

 

[Evi]

Is there anything in the OnPrint or OnFormat events which negates your
query?
Evi

 

[Allen Browne]

Change your query into an Append query, so it writes the values into a
temporary table. Base the report in ths table, and you can then preview or
print as you wish.

 

[Peter Irwin]

Change your query into an Append query, so it writes the values into a
temporary table. Base the report in ths table, and you can then preview
or print as you wish.

Thank you Allen, I am going to try this out.

Peter