Drop down allowing other values

[domtrump]

I have a ComboBox control on my form (bound) that has two choices for the user to select. However, they are still able to type values other than the two I specified. The following properties are set:

Limit to List = Yes
Allow Value List Edits = No
Show only row source values = Yes

What am I missing?

Thanks

 

[Norie]

What happens when the type something not on the list and try to move to another field and/or save the record?

What do you want to happen?

 

[domtrump]

What happens when the type something not on the list and try to move to another field and/or save the record?

What do you want to happen?

It accepts the value and moves on. I want the user to ONLY be able to select one of the values in the drop down.

 

[boblarson]

Make sure you don't have anything in the ON NOT IN LIST event. But it may be corruption sneaking into the form. Try this - open a new, blank database file and import that form. Then from your current one, import it back in (make sure to turn Name AutoCorrect off before you do this) and then open it and see if it does the same thing. If it then works, delete the form that didn't work and then rename the one you imported back in to the old name.

 

[Norie]

Does the control source of the combobox have a default value?

 

[domtrump]

Make sure you don't have anything in the ON NOT IN LIST event. But it may be corruption sneaking into the form. Try this - open a new, blank database file and import that form. Then from your current one, import it back in (make sure to turn Name AutoCorrect off before you do this) and then open it and see if it does the same thing. If it then works, delete the form that didn't work and then rename the one you imported back in to the old name.

I followed these steps, but I get the same result. I can still type whatever I want in this field.

 

[domtrump]

Does the control source of the combobox have a default value?

No, it does not have a default value. I don't want a value pre-selected since this will affect other values on the form. I don't want them to accidentally take the default - they need to choose every time.

 

[Norie]

I can't recreate this problem.

Is there definitely nothing else going on?

 

[domtrump]

OK, I found it (though I still don't quite understand it). Access basically ignored the properties I set on the control and used the properties on the bound field itself. When I went in to the the design of the table itself, I was able to change the settings on this field to those described abouve (on the Lookup tab) and I now get the desired behavior in the form. Guess I was wrong for thinking the form control's properties would override the fields properties. (I kind of wanted to do it this way so that I could change the value in the table if I needed to, but users who were using the form couldn't).

Anyway, thank you both for your help. One last thing, is there a way to NOT let the user tab out of this field if they have NOT made a selection? I know it wont let them add the record until they do, but it would be nice to freeze them in their tracks until they choose one of the options.

Thanks.

 

[Norie]

It should do that if you've set Limit to List to Yes.