Results 1 to 5 of 5
  1. #1
    TheHarleygirl2005 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2013
    Posts
    34

    Find data in a combo box


    I have a form that contains two combo boxes with two columns each (name and EIN) The Ein is bound to another field in the form. The problem is that there are over 300 names to scroll through in the combo box. I have them sorted alphabetically but it is still time consuming to scroll through 300 names to find the right one. Is there a way to make it so i can start typing the name and it will find that record in the combo box?

  2. #2
    dreday's Avatar
    dreday is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    58
    It should do that automatically. What happens when you try to type in the combo field?

  3. #3
    TheHarleygirl2005 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2013
    Posts
    34
    I can only type the first letter. For example if I'm trying to find someone with the name of Lee I can type the L and it takes me to the first name with the letter L but when I type the e, it takes me to the first name with the letter E

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    That's not the normal behavior! Normally it would do just as you need. My guess would be that the Combobox Control has become corrupt. Also, although we usually think of Forms, and even entire Databases, when we speak of corruption, Controls, such as Command Buttons and Comboboxes, can and do become corrupted, and seem particularly susceptible to this during app development. The test/cure for this is short and simple...delete and then re-create the Control.

    Linq ;0)>

  5. #5
    TheHarleygirl2005 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2013
    Posts
    34
    OK, I will try that and see if it works. Thanks!

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

Similar Threads

  1. Combo to find record on report
    By djclntn in forum Reports
    Replies: 2
    Last Post: 04-03-2012, 02:54 PM
  2. Can't find records in combo box
    By darklite in forum Forms
    Replies: 6
    Last Post: 07-07-2011, 02:33 PM
  3. Replies: 5
    Last Post: 11-13-2010, 04:56 PM
  4. Find as you type Combo boxes in MS Access
    By HAPPYWITHU in forum Programming
    Replies: 13
    Last Post: 06-03-2010, 08:41 AM
  5. Find data, load data, and save as a new record
    By hawzmolly in forum Access
    Replies: 0
    Last Post: 10-05-2008, 03:18 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