Controls on drop down lists

[sooz9]

I have a form with drop down lists in which the user selects an item from the
list. The problem I have is that my employee keeps deleting the item from the
list. The drop down list is assocaited with another table so all I do is go
back and retype the item that was deleted to restore the information.

How to I make the drop down lists so the user can still select fromt he
list, but does not have the ability to delete it? When I set controls as
Enabled "yes" and Locked "yes" I can drop down the list but cannot select an
item from the list. When I select enabled "yes" and locked "no" the user can
delete an item from the drop down list.

 

[Jeanette Cunningham]

Hi sooz9,
I just tried to delete an item from a combo's list and it wouldn't delete. I
tried every way I could think of to make the combo delete from its list -
but there was no setting that would allow this.
Where does your combo get its list from? Is it based on a query or a value
list?
Is there some other form that allows records to be deleted and after that
they no longer show up in the drop down?

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Chegu Tom]

Option #1. TALK to your EMPLOYEE!!!

You must be making your list from a table that your employee uses for some
other purpose and deletes the record while doing something else
Make a separate table for the combobox source and don't tell the employee
where it is.

 

[Linq Adams via AccessMonster.com]

As Jeanette said, this is not normal behavior. There are hacks for
deliberately deleting an item from a combobox after it's selected, but it's
not an easy thing to do. Chegu Tom's guess about someone deleting the items
from the table elsewhere in the app sounds like a good a better bet.