combo box search

[amavadia]

Hi,
I currently have a table with a load of customer details: tblCustomer
and i have a form with a combo box that looks up the customer's record with a drop down menu by the surname then the firstname columns from tblCustomer.

The problem i have is there will be over 2000 customers in the system eventually, and a drop down box just isnt going to work, so i need a method of somehow when the menu from the combo box comes down, of selecting a letter from the alphabet and then a list of all the customers with surnames beginning with that letter showing up.

anyone have any ideas please?

 

[Smart]

When you select the combo box arrow (and opend the combo box) you should
be able to type a letyter on the keyboard and the combo box will start with a name with the letter typed

 

[amavadia]

yep i get that, but i need a little menu to select the letter of the surname because its for my ICT coursework and im not going to get the mark unless i do that apparently