Having to enter Query parameter twice

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • yiotie
    New Member
    • Mar 2007
    • 4

    Having to enter Query parameter twice

    Hi
    Each time i run a Query ' find customer by Name " I must enter the customer's name twice to get the results.

    I dblclk the Query, the parameter field appears asking for the customer's name, i enter it , and click Ok, then the parameter field appears again empty asking the customer name again, i enter it , and works fine.
    I deleted and created the query many times but still the problem remains the same.
    Win Xp Pro, Access 2003
    Besr Regards

    Yiotie
  • ADezii
    Recognized Expert Expert
    • Apr 2006
    • 8834

    #2
    Originally posted by yiotie
    Hi
    Each time i run a Query ' find customer by Name " I must enter the customer's name twice to get the results.

    I dblclk the Query, the parameter field appears asking for the customer's name, i enter it , and click Ok, then the parameter field appears again empty asking the customer name again, i enter it , and works fine.
    I deleted and created the query many times but still the problem remains the same.
    Win Xp Pro, Access 2003
    Besr Regards

    Yiotie
    Delete the Parameter in the Criteria Field, then reinsert it.

    Comment

    • pks00
      Recognized Expert Contributor
      • Oct 2006
      • 280

      #3
      Is the parameter prompt exactly the same? Could there but a suttle difference like a space or something?

      Comment

      • yiotie
        New Member
        • Mar 2007
        • 4

        #4
        Originally posted by pks00
        Is the parameter prompt exactly the same? Could there but a suttle difference like a space or something?
        Yes, the parameter prompt is exactly the same

        Thanks for the reply

        Comment

        Working...