Print a Report causes ReQuery

[tbonehwd]

When ever I run a report after the report finishes I go to file print and it starts running the query again. I never noticed this until I upgraded to Access 2003 and for one of my reports it takes 10 minutes to run and it seems another 10 minutes to print anyone know anything about requery upon print?

Thanks,

Tbonehwd

 

[dhookom]

Switching from preview to print will always requery. If it takes so long, you might want to optimize your report or push your records into a temporary table.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]