combo box, restricting selection to what's in the list

[sandra64]

I have a data combo box which consists of a record set. I want the user to be able to just choose what's in that list. At the moment it's letting the user put anything in that box. There must be a simple way of doing this, in access it is limittolist property on the object but I can't seem to find something similar in VB 6.0.

any suggestions?

 

[Trowser]

I think if you select the combo box and set its properties to locked it allows you to select an item but doesn't allow the user to type into the box thus changing the field

 

[sunaj]

set the style to 2 (dbcDropDownList). Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'