Keeping Score on a Form

[matthewnsarah07]

Hi
I have a questionairre set up as a database.
All the questions are set as fields with yes/no answers from a check box on the form.
Once each question is answered there is a score field next to it giving a score of either 0 or 20 which is currently a combo box.

How would I set up the form so that when the yes/no box is checked it automatically updates the score to 20 and records it in the appropriate score field?

I also have a Total Score field how can I add up all the Score fields and store the total in this field?

Question fields are called - Q1, Q1 etc. and Score fields Score 1 etc.

Thanks for your help
Matt

 

[Luddite Lad]

You will need to force the form to refresh, after each check box is clicked.

 

[matthewnsarah07]

What would I need to to set up the force refresh, so that it adds the score in opposite field, I'm a novice at this

Thanks

 

[John Big Booty]

matthewnsarah07 if I've read your opening question correctly, you have a series of Yes/No a a series of corresponding fields in which you are storing a score.

All you really need is the check boxes. A Yes/No check box returns a value of 0 if unchecked or -1 if checked. so there is no reason to further store a score. On your form you just need an unbound Text box with the Control Source set as =Abs(Q1.Value+Q2.Value+Q3.Value..........+Qx.Value)*20 this will update as each Yes/No is checked or unchecked