I would like to lock a subform that contains a table after information has been entered into it, but before it is sent to a user to enter data into another subform that contains a table. Is there a simple solutions? Please see below picture.
You would use the normal .access code to disable the subform. By making the code work at the top level of the subform, everything in it will be disabled.
You need to decide how the code is triggered. Do you want it to execute from a button click, PrePrint, PreSubmit. The same code is needed.
You might want to build in a way to unlock it as well. Create a way to have .access = "enabled";