How do I stop a user editing/changing a field once updated?

M

Mazzara

I have tried locking the field by creating an event procedure for "After
Update" but once you close the record and go back in you can edit the data
you have entered.

I need to stop this to for data integrity purposes, for example, a person
enters a date that is linked to their performance measure once this date is
entered I don't want it to me changed.
 
K

Keith Wilby

Mazzara said:
I have tried locking the field by creating an event procedure for "After
Update" but once you close the record and go back in you can edit the
data
you have entered.

I need to stop this to for data integrity purposes, for example, a person
enters a date that is linked to their performance measure once this date
is
entered I don't want it to me changed.
Click to expand...

You need to test the control in the form's current event as well as the
after update.

Keith.
www.keithwilby.com
 
Top