RECORD LEVEL LOCKING IN SUBFORM
Posted on 2013-11-19
Is there a way to lock a single field in one row of data in a continuous subform?
I have a main form that has invitation numbers that is linked to a subform called children that displays all invited children. In the subform there is a checkbox called attended. If the child attends the event, this box is checked. Once checked, it becomes locked and not editable unless an admin logs in. An invitation number can be related to one child or more within the same family.
However, when I locked the checkbox on the after update property when the value = yes, all records related to the invitation number is locked. Sometimes only 2 out of 4 children attends even though the 4 has been invited.
Any assistance will be appreciated.