Locking a record

[Mellie]

Hello

My goal is to lock records once a check box is checked. The question is:
Completed yes or no? Once the yes is check I want that record to be locked
from editing. There is no subform right now. Do I need to create a subform
or can it be locked with out the subform?
Thanks

 

[NetworkTrade]

there is more than one way to do this; and there is some tricky aspects
depending on how you percieve the overall user experience is to be
"managed"....

can one do the equivalent of locking all fields by putting the form's 3 key
controls to false
AllowEdits
AllowAdditions
AllowDeletions


Setting these form properties to False may accomplish your goal, but they
also affect whether new records can be shown and whether any records are
shown.