Type ahead with Listbox

[AEC]

Users are never satisfied. They want the same functionality with a list box as with a combo box. The ability to type ahead in a list box.

Does anyone knows how I could use the Keypress event to create the type ahead functionality.

Your help would be greatly appreciated

 

[apr pillai]

Take a look at the following link:

http://www.msaccesstips.com/2009/04/filter-by-character-and-sort/

 

[AEC]

Thanks for your respond APR. There are lots of interesting stuff there.
I am going to experiment using a combo box instead of a textbox and see how it goes.

 

[AEC]

APR I found some code which I adapted to work with a combo box and it work a treat. Thanks for your input.