Entering Text in Combo Form

[Bobt]

This is a very basic question. I have created a combo box. I have it set to a control source with a query lookup to populate value list. I can select an item in the list with a mouse click. However if I type the value in, it is not accepted. Can typed values be entered in a combo box that do appear in valid list? If so, what properties do I have set that is preventing me from typing value into combo box.

Thanks,
Bob

[NTC]

Yes, in the properties of that combobox control. Can't remember the exact 03 term but it is something like 'Restrict to List'...in any case scroll down thru all the properties and you'll know it when you see it.....

Hope this helps....

[Bobt]

I left out one important detail. The combo box is bound to a primary key. However, another database column is displayed which means something to the user - i.e. location code. So when a user picks a location code from the list, it references the corresponding primary key and the record is loaded. When they type into the combo box the location value, the combo box is actually looking for the primary key and not location code.

What is best practice in allowing them to type in location code and then have corresponding primary key load respective record into form?

Thanks,
Bob