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

    search and show

    Hi,

    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.

    Example,
    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"

    Thanks

  2. #2
    recyan's Avatar
    recyan is offline Expert
    Windows 2K Access 2000
    Join Date
    Dec 2011
    Posts
    662
    Check out "Like".
    See if below is of any help.
    http://office.microsoft.com/en-us/ac...001032253.aspx

    Thanks
    ______________________________
    - 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