Continuous form working with a single record

[plucnik]

Let me preface this with I know just enough VB to be dangerous
I'm working with a form that has a subform. The subform is formatted to display multiple records from a query in a continuous form. Each record has several yes/no checkboxes. I want to disable several of the checkboxes in a record when one particular checkbox is "true". I put this simple bit of code in the "on click" event behind the checkbox that I want to trigger the event.
If [workdaycheck] = true then
[3pct].enabled = false
else
[3pct].enabled = true
end if
Simple but.........this effects ALL of the records (disables all of the [3pct] checkboxes) in the continous form, not just the record that the [workdaycheck] was made true. How can I isolate the action to a single record and not all the records in the subform? Thanks!

 

[plucnik]

Thanks Pat.........I'm working with an existing program that I do revisions on. An option group is probably the right way to go. Thanks for the info about putting the code behind the form as well. I'll try that and post the results.

 

[plucnik]

Just wanted to let you know that putting the code in the Current event on the form in addition to the on click event on the yes/no box did the trick. Thanks!