Bound for Autosearch

[drunkenneo]

I have a form bound to a table for updation:

Table
------


name
address
Stat fk ref cod

Cod
------
id
stat PK

in the form in textbox for stat column, shows list type box, and stat has 3 letter alphabet only. My problem is when i press key for enterin Eg. ABC, this shows A and letter starts with A, B letters Start with B...and so on.
I want it if i press ABC then it should show me ABC Only. Please Help.

[June7]

Listbox will not work like that and is not intended to. Maybe VBA code could achieve that but why bother?

Combobox has AutoExpand property.

[drunkenneo]

I changed my list to Combo to prevent complications, it worked