Results 1 to 3 of 3

Thread: parameter query

  1. #1
    Join Date
    Aug 2004
    Posts
    5

    Question Unanswered: parameter query

    I hope this is an easy one. I have a combo box for county name and number- the data is in the combo box like this 10-Carter. I want to query by county. I put in this code in the criteria space Like[Enter County Name]&* This allows you to search by the entire name or the county number. What I want to be able to do is search name. Right now, if all you enter is Carter, no results will be returned. Is there another parameter that can be used or is the combo box set up wrong?

    Thanks!

  2. #2
    Join Date
    Jun 2004
    Posts
    92
    Try This:

    Like "*" & [Enter County Name:] & "*"

  3. #3
    Join Date
    Aug 2004
    Posts
    5
    That did it! Thank you very much.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •