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

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Freeze fields with a command button click 4
How do I stop a user editing/changing a field once updated? 1
Lock only updated record 5
Lock Editing of a single field 3
making a field editable once it has data. 4
Access Form - Lock Fields from Editing 0
Error "Field can not be updated" when entering data in a subform 3
How do i create a condition to a field in the form in access 2007. 1

Top