Bound Form textbox 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.

 

[CJ_London]

Do you mean you want to select a stat from a list and you only want to see name and address from Table where stat equals the one you selected?

 

[David R]

Your search box should be UNbound. Your form fields once it comes up should be bound.

 

[Drunkenneo]

Do you mean you want to select a stat from a list and you only want to see name and address from Table where stat equals the one you selected?

yes, but also to inform i have list around 2000 and if I type A it will show Starts from A and for ABC i have to press down arrow to select, where i need only want to do it in prees of ABC Keys.

 

[CJ_London]

Are you saying you have a list of 2000 stats? or that having pressed A you have 2000 table records?

Are you using a combo box or a list box?

Can you past an example of the db where you are having a problem