Combo Box with State Abbreviations

I have a Combo box on my form in Access 03. I need help on coding the combo box so that when a user hits T (for example), it will jump to the first state that starts with a T, and if T is hit again it will move to the next state that starts with a T and so for, for any lett开发者_开发百科er. Also should the row source type be a Value List or Table/Query? Thanks.

No need to code my friend just set the rowsoruce to your query and then set the “Auto Expand” property to “Yes” and access will take care of it for you

For what it's worth, listboxes DO behave the way you suggest. If you're really set on this, you might use a textbox and listbox to "fake" a combo box. Of course, the reason it's called "combo box" is because it's a combination of two controls, a textbox and a list, so you'd be re-inventing the wheel, but you could then get the behavior you want.