Hello, sorry about the lengthy question.
Even with using oncurrent, (say disabling textboxes), my problem is if I move to the next record, it will run that code and disable textboxes which is a similar problem.
As an example say on Record 1 I want to have a checkbox which if ticked enables...