Report Print Issues (1 Viewer)

NearImpossible

Registered User.
Local time
Today, 16:39
Joined
Jul 12, 2019
Messages
177
On one of my forms, I have a report that is generated from 3 queries, which are based off of a couple fields from the form, then displays in print preview and saves to the network as a PDF. After this is completed the form closes.

This all works fine, but when trying to print the report from the Print Preview window, it tries to rerun all the queries again before printing, but as the form is closed, the required info is no loner available so it is prompting for the required info

Is this normal behavior or am I missing something?

If its normal, I just won't close the form until the report is closed.
 

theDBguy

I’m here to help
Local time
Today, 14:39
Joined
Oct 29, 2018
Messages
10,714
Hi. I just did a quick test and can confirm the behavior you're seeing. My guess would be that this is a normal behavior designed into Access reports. Just my 2 cents...
 

Micron

AWF VIP
Local time
Today, 17:39
Joined
Oct 20, 2018
Messages
3,115
AFAIK, this is normal and there are other events that run when navigating from page to page. This also means that the use of global report variables that store calculations can be 'dangerous' as they can calculate based on pages or events. You might preview page one of a report and look at a footer total and many not notice the final tally is vastly different from the printed report.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom