Lock a Field After Data Entry

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

Guest

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.
 
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.
Click to expand...

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
 
I'll try that - it might solve my problem. I do welcome other ideas. Thank
youl
 
You must log in or register to reply here.

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

Updating tables when you input new data 0
Form Suddenly Became Non-Editable? 1
Subform Data Entry Setting 0
ZoomBox help 1
Access Daily Entry with multiple entries per field 0
lock field after data input 3
Locking specific data in a continous form 2
Can't tab through datasheet subform 2

Back
Top