Locking the contents of a combo box?

[t3nchi]

I have a combo box whose row source comes from a table. I want ppl to be able to select from the combo box but I don't want them to be able to make any changes to its content (in the table).

How do I do that? I've fiddled around with the Lock features in the forms but I cannot get the right setting. Advice? thanks.

 

[ejstefl]

The most simple answer is to not allow them access to the table!! There is no way to change the values stored in a combobox from a combobox, so as long as you have "Limit to List" enabled, and the user can't see the table, they won't be able to change the list.

 

[t3nchi]

The most simple answer is to not allow them access to the table!! There is no way to change the values stored in a combobox from a combobox, so as long as you have "Limit to List" enabled, and the user can't see the table, they won't be able to change the list.

Ah that's what I meant,limit to list. Thanks.