Customer look UP

[Simon]

I have a large amout of cusomers on the database now.

I would like a way to find them faster. Is there a wasy that as i start
to type in a customers surname in a text box it filters out the
customer surname with the letters i have typed in the box


Thanks

 

[Pietro]

Sure..
First you should change the field box into a combobox
Then on the rowsource of this combobox write the follwoing SQL code:
SELECT fieldname FROM queryname;