Results 1 to 4 of 4
  1. #1
    batowl is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Dec 2010
    Posts
    86

    Asking For Parameters Twice

    I am trying to run a report based upon query results. The criteria for the query are set via parameters so that when you run the query, the box "Enter Parameter Value" box comes up. That is all well and good. The problem is that this box requesting parameters comes up when you run the report as well. That is a problem because I have a macro built to run the query, then the report and this makes it so that each parameter has to be entered twice. Is there any way to stop Access from asking for the parameters before the report is created? Thank you.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Why are you running the query before? If the report is based on it, all you have to do is open the report. It runs the query, and you'll just get prompted once.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    batowl is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Dec 2010
    Posts
    86
    Oh man, I did not know that. Problem solved. Thanks!!

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    No problem; common misconception.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Parameters
    By butl3111 in forum Access
    Replies: 1
    Last Post: 04-14-2011, 10:29 PM
  2. Parameters
    By Alaska1 in forum Access
    Replies: 1
    Last Post: 03-30-2011, 02:05 PM
  3. Too few parameters
    By jgelpi16 in forum Programming
    Replies: 1
    Last Post: 12-23-2010, 10:28 AM
  4. Too Few Parameters
    By jgelpi16 in forum Programming
    Replies: 8
    Last Post: 09-27-2010, 01:46 PM
  5. Input parameters
    By GloriaLuz in forum Reports
    Replies: 0
    Last Post: 11-14-2005, 09:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums