"You need to use the one on the form. Use it to check the value of the checkbox and enable/disable as appropriate."
Yes, I've tried it as you suggested. But It doesn't disable right after I tick the check box, only when I go to the next record or Refresh All.

There is no On Current event for check box control, only for the Form in general. In this case for the action to take place I need to either go to next record or push Refresh All. But I would like to have a check box that disables some of the fields while user can continue to work with other fields for this record.
What I'm thinking is - I can use On Current event of my form, and use the check box to run Requery command, but this command takes...

Hello,

Here is my question.

I've got several check boxes on my form (yes/no questions for users). And one check box that says "None of the above".
If the latter is ticked: 1) all other check boxes become disabled, and 2) Access checks if any of them were ticked and if it's true alerts user about the error.

For #1 I wrote a code in After Update event to disable all other boxes, but it...

Hello,

I've got a stupid thought on this topic. What if in a subform property sheet I go to "Format" and change "Navigation Buttons" property from Yes to No. This way I simply eliminate the possibility for user to go to next record in the subform and user can only work with one record. Please advise if this approach is acceptable.