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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.

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

Keith.
www.keithwilby.com
 
Back
Top