In datasheet form, is there a specific way to lock (not allow edits) to one of four data fields which are not limited to list and still allow delete/add records too?
I can find it on the form property but not at the data field level. When I set it on the form property (Allow Edits = No) I cannot add data to the left/right of existing records.
This example might be helpful:
PN Desc Date Color
1212 Thing May 2010 Green
3212 Another May 2010 Blue
This data shows when the form is opened, I do not want the user to be allowed to edit the PN field but they are allowed to edit the other 3 fields. (At least that's the plan now)
Sorry my example got smushed together when I submitted, hope you can figure out what I was trying to communicate.