Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    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 .
    Thanks
    Silverback
    Silverback

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    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...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •