Protection Of Data Fields in Forms

C

Colin Hook

Hi,
How is it possible to protect data fields in forms so that if a user
wishes to alter a field with data he or she is prompted "Do You Really Want
to Do This?". I understand that the fields should be Locked initially but it
is how to automate the Unlocking and Locking once the Field has been altered
that i am interested in.

Any help will be greatfully received.

TIA
Colin
 
K

Kc-Mass

Colin
If the field is locked there won't be any alterations. The user
cannot change the data in a locked field.

If you want to give them the option of changing it, but caution them,
unlock the field. In the before update event use a msgbox to
caution them and then based on their response and any
validation of the new data either cancel the update or
let it go through.

Kevin C
 
Top