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

 

[boblarson]

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)

That is one reason why we say DO NOT USE LOOKUPS AT TABLE LEVEL!!!!!!! Use them at form level ONLY. Get rid of your table level lookups and read this for more information as to why table level lookups are BAD, BAD, BAD ......
http://www.mvps.org/access/lookupfields.htm

 

[domtrump]

That is one reason why we say DO NOT USE LOOKUPS AT TABLE LEVEL!!!!!!! Use them at form level ONLY. Get rid of your table level lookups and read this for more information as to why table level lookups are BAD, BAD, BAD ......
http://www.mvps.org/access/lookupfields.htm

OK, thanks! I'll give it a read

-Dom