I have a multi-user A2007 DB split front/back end. All user activities are done via forms. At its core, this is a contact database, with detailed event and corporate affiliations pulled together on one form.
Each user is assigned specific records to maintain contact accuracy. I don't know how to write my own user-level security, so users are on the "honor system" to not modify records that are not within their assignment.
I have a combo box which uses a value list with a row source of "active";"inactive" Unfortunately, a small number of stubborn users insist on toggling this field for contacts which they do not control. They often make mistakes and "inactivate" contacts unnecessarily.
My only idea thus far is to set a default value of "active" for the field and then set the locked property to "yes". Would this allow users to add records as normal, with the "active" designation in the field....and also prevent them from changing that field? My intent is to force users to consult me before inactivating contacts(this is rarely needed at this point in time.)