How do I stop a user from changing a field once updated?

M

Mazzara

Once a user has updated a field in a form, how can I stop them from changing
the information that they have entered. For example, if they are entering
the date they received a document, how can I lock in that date so that they
can't change it.
 
A

Allen Browne

If you want to lock a field named EntryDate so that it cannot be changed
after the new record has been entered, add this line to the Current event
procedure of your form:

Me.[EntryDate].Locked = Not Me.NewRecord
 
K

Keith Wilby

Allen Browne said:
If you want to lock a field named EntryDate so that it cannot be changed
after the new record has been entered, add this line to the Current event
procedure of your form:

Me.[EntryDate].Locked = Not Me.NewRecord
Click to expand...

I wish I'd seen this before I answered this question's twin!

Keith.
 
Top