Combo box to increment search AND hide others

S

Song Su

I know how to use combo box to search names. I want it to do further: hide
those not starting the character I'm typing. For example:

When I type the 1st letter S, it shows all the name starting with S and hide
those starting T, U, V etc. When I type 2nd letter M, it shows the name
starting with SM but hide those staring SN, SO, SP etc.

Is it possible?
 
K

Klatuu

It can be done, but I would advise against it. It takes a lot of VBA code
and because the way it has to be done, it will make the combo very sluggish.
Most people can type faster than it could respond. That is because you have
to modify your row source for every keystroke and requery the combo. If you
want to try it, use the combo's Change event. It fires after every keystoke.
I call tell you the users will hate it.
 
Top