Selecting Record

[amavadia]

I have a table with customer details, probs over 3000 customer, and i need a method of selecting the customer in a form by their surname. Currently i have a combo box, but as you can imagine, this is not practical with so many records. anyone think of any other way to do it?

 

[Krikkit]

Keep the combo box, but instead of selecting the value, type it into the combo and it should auto-correct you (if you've not switched that property off).

 

[amavadia]

yea but i need another method. maybe by splitting it up by first letter of surname somehow. i kno the autocomplete would work but the end user has requested an alternative way

 

[sehmke]

You could make a unbound field "startchar" in which end-user can enter a character, upon clicking a button, you can requery the source of the dropdown so that only names starting with the letter in field "startchar" are shown.

 

[amavadia]

how do i do that mate