enabling AND disabling one control on continuous form

[w11184]

I've been wreaking my brain trying to figure this out and I have a feeling i am looking at it the wrong way.

Basically I have a continuous form with each record having a textbox and a checkbox. There can only be one checkbox ticked per record but what I want to do is to stop the other checkboxes from being ticked if one is already ticked. Can anyone point me in the right direction in achieving this?

thanks!

 

[pr2-eugin]

Achieving this in a Continuous Form might be tricky.

 

[w11184]

I know... But there must be a way of doing it.