Does anybody know how to use the combo boxes to search a table so that the only values shown in the list match the value entered at the keyboard?

e.g When you type 'A' all the values in the database begining with A are returned. If you then type 'N' all the values starting with 'AN' are returned.

At the moment when i do this only the first letter is used to search and you can't see what is typed.

The control in Access seems to work properly, is there another control i can use or does anyone know any code which will enable me to perform the task mentioned?

thx in advance