Locking forms cont.d 1

[austen]

Sorry I feel I was not clear.
On the form I have a check box. This relates back to the main table.
What I want to do is once the form has been checked by one person they then have the authority to tick the box. On doing so they lock the box making it un-editable. However, I wish people to use the same Form to add new records and therefore write to the form. Is this possible at all or am I asking too much? I am unfamiliar with code therefore would need assistance with this and more use to form/queries/tables etc.

 

[Remou]

Do you mean that Joe Authority looks at record No. 1 and locks it, then Joe Plain comes along and adds a new record, No. 2, but cannot change record No. 1? If so, you can use the Current event to lock the form and thereby the record. If you say:

Me.AllowEdits = Not Me.NameOfLockFieldHere
Me.Deletions = Not Me.NameOfLockFieldHere

Then AllowEdits will only be true (yes) if NameOfLockFieldHere is not true, that is, not ticked.