Assign a value to a check box

I am using Access 2003. Would like to assign every team member a score,
depending on their performances.
To this aim, I am building a form with team members general info, and then
in a subform I'd like to have for each question 3 choices (3 check boxes);
each box should correspond to a value (3 if great, 2 if average, 1 if needs
improvement).
When clicking on the check box, the score (3, 2 or 1) would appear in
another box on the same row.
At the end it would give me the total score of each team member based on
these questions.
I am new with Access, can you help me on building that?
Thanks!

I would recommend that you use an option group. I would also recommend using
radio buttons (the round dots) over a check box. With an option group, you
can only select one vaule and the selected value is automatically stored.
Then it would be very easy to sum the values from the multiple rows of the
sub form to get a total score.

--
Boyd Trimmell aka HiTech Coach
http://www.officeprogramming.com
http://www.hitechcoach.com


"Violaine" wrote:

I am using Access 2003. Would like to assign every team member a score,
depending on their performances.
To this aim, I am building a form with team members general info, and then
in a subform I'd like to have for each question 3 choices (3 check boxes);
each box should correspond to a value (3 if great, 2 if average, 1 if needs
improvement).
When clicking on the check box, the score (3, 2 or 1) would appear in
another box on the same row.
At the end it would give me the total score of each team member based on
these questions.
I am new with Access, can you help me on building that?
Thanks!