If you create a table-based combo box and a form to go along with the table, setting "Allow Value List Edit" to Yes or No wouldn't have any effect with the end user ability to change the form. That is to say, even though you set the "Allow Value List Edit" to No, the end user is still able to change the form and hence change the list of options of the combo box.
The only way to prevent the end user to change the list is by leaving "List Items Edit Form" blank. That is to say you must remove the reference to the form that let you change list.
Is it a bug or am I missing something here?
Hendra GunawanOP
@Reply 4 years ago
Hendra GunawanOP
@Reply 4 years ago
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 8.