Keep prompt Enter Parameter Value when create Queries

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mrijet
    New Member
    • Feb 2015
    • 64

    Keep prompt Enter Parameter Value when create Queries

    Hi everyone,

    When I create queries, the message box prompt Enter Parameter Value keep prompting when I run queries. It happen when I set the criteria as Forms!SalesForm !SalesID


    I make this queries because want to view the report by only specific data.

    I dont know what actually I miss to avoid the message box prompt telling Enter the parameter Value.

    Any suggestion are appreciated.
  • Luuk
    Recognized Expert Top Contributor
    • Mar 2012
    • 1043

    #2
    search Google for: access prompt for parameter

    one of the first hits:
    Use parameters to ask for input when running a query

    This explains how to create a prompt.If you understand this you should be able to remove the prompt you have now.

    Comment

    Working...