Avoid re-queries when printing report

  • Thread starter Thread starter Peter Irwin
  • Start date Start date
P

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
 
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.
 
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.
Click to expand...

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

Peter
 
Back
Top