Results 1 to 2 of 2
  1. #1
    italianfinancier is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    25

    Question Access Report Keeps Asking for Parameters

    Hi, I created a report that generates after a user enters a customer number in on a form and clicks "OK". When the user enters a customer number and clicks the button, Access displays a dialog box asking for parameters (i.e. customer number, etc.). I have the sub-reports on the report linking to queries and have set it up so that the queries have a criteria to only show data relating to the customer the user entered. How do I get Access to stop asking the user to enter the customer number so many times? I really want it to just take the user number entered on the form and automatically use that number as the parameter.



    Any help would be GREATLY appreciated!

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    This usually occurs when there is a mis-spelling in the reports or queries. Double check all of your field names in your report that they match up with the queries and tables.

    As an aside, if you run the queries apart from the report, does Access run the queries correctly? Or do you get a parameter request there also?

    Alan

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

Similar Threads

  1. Replies: 3
    Last Post: 02-22-2011, 01:28 PM
  2. Replies: 0
    Last Post: 07-05-2010, 08:00 AM
  3. Report parameters
    By saylindara in forum Reports
    Replies: 15
    Last Post: 08-02-2009, 03:49 PM
  4. Passing parameters to a report
    By elmousa68 in forum Access
    Replies: 0
    Last Post: 12-07-2006, 01:38 AM
  5. DISPLAY INPUT PARAMETERS ON THE REPORT
    By fadone in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 10:26 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