Results 1 to 2 of 2

Thread: Wildcard Search

  1. #1
    Join Date
    Jan 2007
    Posts
    1

    Unanswered: Wildcard Search

    I have created a search form in my access database using command buttons and macros. I can find my records in the database, but only if I type them in the same way as they were input on the form.

    What do I need to do in order to allow my users to input various portions of either the text or numbers on my search form and still get my records to appear?

    Please help!

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    In the WHERE clause that you're building, instead of using

    WHERE somefield = '" & cmbInput & "'"

    try using

    WHERE somfield LIKE '*" & cmbinput & "'*"
    Inspiration Through Fermentation

Posting Permissions

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