Combo Box - Limiting what is listed inconsistently

[Kathy]

In many of my databases, I use combo boxes to look up a
customer, video, etc....

At times, my list will look like it's doing okay, but it
won't go to the end of the list. (The lists aren't
extremely long, say 10,000 records in the big database.)

Unfortunately, there's no consistency to when it does
this.

If i'm looking for say Johnson, Mary, the list will
actually go to the Z's, and if you type a name beginning
with Z, it will complete that name in the combo box, but
the list won't move to it.

You can't force it to go to the end????? This
doesn't always happen, and there's no way to predict when
it will happen.

It is happening now in one of my DB's, and it's
driving me nuts.

Thanks for any help.

 

[Sandra Daigle]

Hi Kathy,

I can't put my finger on an article that explains this problem (I think
there might be one) but 10000 records is a lot for a combo box. Often when
you start running into problems with listboxes and combos it is time to
start trying to limit the results in the list. Not only because of the
technical issues that crop up but also because it makes it nicer for the
user (usually anyway). Here are some links to a couple of articles that
describe different ways to limit the contents of a list (Combo or listbox).

http://www.mvps.org/access/forms/frm0028.htm
http://members.iinet.net.au/~allenbrowne/ser-32.html