Results 1 to 2 of 2
  1. #1
    zbug is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2010
    Posts
    1

    Query prompt issue

    I have a query that prompts for user input, basic query with the following in the criteria of the field status. [enter staus] problem is when I run the query it prompts the user for the status and multiple other criteria's. There is nothing in the criteria filed of these other fields.



    any help is greatly appreciated

  2. #2
    jzwp11 is offline VIP
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    Welcome to the forum!

    Does your query get its data from another query that requires parameters? If so, then you are getting prompted for those parameters as well.

    If your query is not based on another query, then you will need to look for misspelled table and/or field names in your query.

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

Similar Threads

  1. Replies: 5
    Last Post: 03-04-2010, 05:41 AM
  2. Password Prompt
    By thestappa in forum Security
    Replies: 1
    Last Post: 01-28-2010, 09:19 PM
  3. Run Report with Prompt for Field Criteria
    By diane802 in forum Reports
    Replies: 4
    Last Post: 01-15-2010, 02:31 AM
  4. prompt criteria issues
    By Rik_StHelens in forum Queries
    Replies: 1
    Last Post: 10-16-2009, 10:17 AM
  5. Removing the delete prompt.
    By botts121 in forum Programming
    Replies: 4
    Last Post: 06-26-2009, 11:45 AM

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