How to add numeric value to a chekbox

[dealwi8me]

I want to get the sum of checked checkboxes.

How can i add values to these checkboxes in order to get the sum of them?

I tried to set the default value of the combo boxes to a number, and then to add them but i can't get a sum value.

Any suggestions?

Thank you in advance!

 

[Smee]

I use a query to change all the values to 1 if true and then sum...

In the field value something like :

New Field Name: IIf([Check Box field name],1,0)

Hope that helps.

 

[dealwi8me]

the thing is that each checkbox should have a diffrent value and at the end i should get the sum all of this values...

Thanks for trying to help me

 

[Bat17]

Check boxes by their nature are are just Yes/No you cant set values. what you could do is create a hiddin field for each box and use the click event of the check boxes to update it.

Private Sub Check1_Click()
If Check1 = True Then
    Me.score1 = 20
Else
    Me.score1 = 0
End If
End Sub

hth

Peter

 

[dealwi8me]

yeap! that's what i thought would be the answer....

Thanks a lot