Sum Check Boxes and Store Value

[colourxpalette]

Hi all,



I'm creating a form where there are 3 yes/no check boxes, and at the bottom, I want a text box to count up how many boxes were checked. I have " =Abs([Y_A]+[Y_B]+[Y_C]) " in the control source of the text box, but I would like to store this number as "Y_Total" in my table.

Any help would be greatly appreciated!

[pbaldy]

http://allenbrowne.com/casu-14.html