Lock a Field After Data Entry

J

JDJones

I have a datasheet subform. Is it possible to lock each field after data
entry? I don't want the user to be able to go back and edit the field.
 
T

Tastic

JDJones said:
I have a datasheet subform. Is it possible to lock each field after data
entry? I don't want the user to be able to go back and edit the field.

I am not sure how to lock the field but hope someone else will help
here, I would love to know as well,

You can however change the field so that it is not enabled after entry,
it is just a matter of conditional formatting: If field is not equal to
"" then disable

this will stop people being able to edit the field, the only thing is
it greys out the field, it is still readable but is a different color
to the rest of your data sheet
 
J

JDJones

I'll try that - it might solve my problem. I do welcome other ideas. Thank
youl
 
Top