using check boxes to return numeric values to a single field

[rlambkin]

Hi

i have a survey form that people need to complete, to make it easier there are checkboxes that designate the value, 0,1,2,3 and 4.

the value is held in the field "score"

So basically, if somebody ticks 2, the value 2 is held in the field score.

However, I am at a loss as to how to do this on an access form, does anyone have any ideas.

Cheers

Rob

PS can a check box be set to use a cross rather than a tick?

 

[Fuga]

Have you tried using an option group?

Fuga.

 

[rlambkin]

that looks like the answer, many thanks