Results 1 to 2 of 2
  1. #1
    Lowell is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Mar 2012
    Location
    Manitoba, Canada
    Posts
    54

    Combo Box search not working

    I have followed this video: http://datapigtechnologies.com/flash...tomfilter.html . It worked good. So, we entered data. Now we have about 400 data entries and I noticed a problem. When I type 23 it wants to bring up 230 and I can't get it to allow me to type in only 23. I have checked my data. The numbers are the record ID and are the primary key. So, what will happen is when I get to th 1000's of entries then I will only be able to bring up those records and not the three digit entries. Does this make sense. I don't know how Access can make this mistake. I have double checked my code with the video and everything is the same. And it seems that this is the only way it works. If you can help please do. I will check back to see if no one can comprehend.

    Thanks,


    Lowell

  2. #2
    Access_Blaster is offline User
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2010
    Posts
    339
    Quote Originally Posted by Lowell View Post
    I have followed this video: http://datapigtechnologies.com/flash...tomfilter.html . It worked good. So, we entered data. Now we have about 400 data entries and I noticed a problem. When I type 23 it wants to bring up 230 and I can't get it to allow me to type in only 23.
    Research the "Like" Operator, It returns everything Like 23, or 02,230,30 other wise you maybe left with empty or null results.

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

Similar Threads

  1. Search Button in a Form not Working
    By spideynok in forum Forms
    Replies: 30
    Last Post: 03-29-2012, 01:10 AM
  2. Replies: 4
    Last Post: 08-16-2011, 05:54 PM
  3. Replies: 9
    Last Post: 05-05-2011, 02:05 PM
  4. Msgbox And Search Code Not Working Properly
    By vampyr07au in forum Forms
    Replies: 1
    Last Post: 05-02-2011, 05:16 PM
  5. Search field is not working correctly
    By jakeao in forum Programming
    Replies: 9
    Last Post: 05-18-2009, 07:47 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
  •  
Tech Forums: Microsoft Office Forums