calculate option box values in a form

[tarek_ta2ta2]

dears,

hope anyone can help me here

i have a form with option box it looks like that


evaluation 1 : bad normal good excellent
evaluation 2 : bad normal good excellent
evaluation 3 : bad normal good excellent
evaluation 4 : bad normal good excellent

what i want is to give every option number for example
bad =1 normal=2 good =3 excellent=4

so at the end the result of the user selection will appear in box
for example if he select in
evaluation1 bad
evaluation2 normal
evaluation3 good
evaluation4 excellent

the result will 1+2+3+4 = 10


i hope i explained what i want and make it clear

 

[JANR]

Make a textbox with it's controlsource: = evaluation1+evaluation2+ etc.
will give you what you want.

I asume that the optionboxframe NAME is evaluation1 etc.

JR

 

[tarek_ta2ta2]

i use word 2oo7

so what i did i use option button from the developer tab

so evaluation one is just a text i wrote the actual option button is the

option button 1:bad
option button 2 : normal
option button 3 : good
option button 4 :excellent

so you have

evaluation 1: bad nomral good excellent
evaluation 2: bad nomral good excellent
and go on

 

[JANR]

My suggestion was for Access not Word. Perhaps somebody else will help you.

JR