Results 1 to 2 of 2
  1. #1
    tmb11152 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012

    search and show


    I made a form and inside this form i have a combo box that returns all the items I have in the inventory(with a query)

    However i ran into this problem.

    in my inventory list, i have items like
    Shoes, ankle, Black

    Shoes, ankle, white
    Safety Shoes.

    When i type shoes, the list of items return to the combobox doesnt not have the safety shoes.

    What critriea can be use to so the query returns any items with matching words that "i enter in the combobox"


  2. #2
    recyan's Avatar
    recyan is offline Expert
    Windows 2K Access 2000
    Join Date
    Dec 2011
    Check out "Like".
    See if below is of any help.

    - My mind doesn't wander, most of the times, it leaves. - S R

    Neither academic background nor practical experience, just a love for Access.
    Requested to test thoroughly, if any advice accepted.

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

Similar Threads

  1. Replies: 12
    Last Post: 03-22-2012, 02:48 AM
  2. Search From List and Key Search
    By netchie in forum Forms
    Replies: 14
    Last Post: 02-23-2012, 01:37 PM
  3. Replies: 1
    Last Post: 06-12-2011, 07:08 AM
  4. Replies: 1
    Last Post: 04-12-2011, 05:19 PM
  5. Replies: 2
    Last Post: 08-31-2010, 08:57 PM

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 - Senior Forums