Searching List Boxes

P

Paco

I have a form with a combo box and a list box (among other controls). What I
want to do is use the combo box to find a record and then highlight that
record in the list box. (I need to use the type ahead feature in the combo
box).

Initially, I used a for-next loop to search for the record in the list box
by comparing the value of the combo box. This works fine for a few hundred
records, but the for-next loop takes a long time with 50K records.

Any suggestions about how to do this. I know there must be a quick, simple
way.

Thanks.
 
Top