Unclicking Check Boxes on a Form

[Troy]

I have a form that lists 13 rows of data that are being
rated on a 0 - 5 scale. I have a check box assigned to
each value i.e. 5,4,3,2,1,0. 6 check boxes per row, 13
rows 78 total check boxes. Only one box per row should be
checked at a time. How do I get each check box when
clicked to unclick any other check box in that row only.

 

[Rick Brandt]

I have a form that lists 13 rows of data that are being
rated on a 0 - 5 scale. I have a check box assigned to
each value i.e. 5,4,3,2,1,0. 6 check boxes per row, 13
rows 78 total check boxes. Only one box per row should be
checked at a time. How do I get each check box when
clicked to unclick any other check box in that row only.

Instead of 6 separate fields with 6 separate CheckBoxes, use a single field where you
store the value 0 through 6 and use an OptionGroup on your form. OptionBoxes in an
OptionGroup frame automatically provide this functionality. When you select one you
automatically de-select the others.