Checkbox query

[Crackers]

I have a Form that I am doing for my local sporting Club that keeps a check of the games played each week by individuals. On my form I have a Textbox (txtGames) and a number of checkboxes that are to be checked if the player plays a game that week i.e.

TotalGames....Wk1...Wk2...Wk3...Wk4 etc to Wk14

If the individual has played for the week, they are checked off under the appropriate Week.

My question is, how do I populate the TotalGames textbox to count the number of checks for each Player.
I have searched on this Forum and have not found anything that resembles my problem.
I am very grateful for any help I can get. Thank-you!

 

[ansentry]

In the footer of your form put an unbound text box and do the following:

Put the code below in your text box and replace "Red" with what is in your control source for the checkbox, Not what is in the name;
Control Source = WK1
Name = chkWK1
You would use WK1

=Abs(Sum([[B]RED[/B]]))