I have read some threads and thought I had it. I want to lock records AFTER the box is marked or clicked. Here is what I have where record completed is the name if the yes/no box. I had added an automatic date afteupdate and it worked very well. However this just doesn't lock the record?
I used this in forms On Current Event:
If Me![record_completed]= true then
Me.AllowEdits=True
Else
Me.AllowEdits=False
End if.
I used this in forms On Current Event:
If Me![record_completed]= true then
Me.AllowEdits=True
Else
Me.AllowEdits=False
End if.