Results 1 to 2 of 2
2008-07-17, 23:13 #1
- Join Date
- Jan 2001
- Warrington, Cheshire, England
- Thanked 0 Times in 0 Posts
Query running a second time (2003 SP3)
I have another problem with the report mentioned here. The report is opened in preview mode from a form which collects the parameters for the underlying query. When the user attempts to print the report preview, she is prompted for the form parameters. I've already worked out that this is because the form which opened the report has been closed - so the parameters are no longer available. I've proved this by commenting out the close form action which results in printing proceding normally, but why is the query running again when printing is requested? All other reports opened in preview mode from the same form do not have this behaviour - the preview for those reports is printed normally. These reports use the same query as the problem report .
2008-07-17, 23:17 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: Query running a second time (2003 SP3)
I don't know the cause, but you already have the solution: don't close the form...