option code

[samm]

HI FOR ALL


NEED OPTION CODE
Three option groubs G1 G2 G3 each groub has three options A B C, and text with option,
all options have value = 1
I want each option selected add with other seletc
I need code for result addition in T1 and text in T2,

textbox ( T1, T2)


Regards;

 

[samm]

thank you so much Pat Hartman

If you have any way to use 0 value for all options EXCEPT one option =1 in each groub.

 

[samm]

thanks

can i use 0.1 or 0.01 for value as adiffernt value

(three columns in the table to hold a value) I dont understand If you can explain more

 

[WayneRyan]

samm,

An option group is just a way of specifying a choice. Let's say
that you have a database about pizzas. Each pizza has a size,
that's perfect for an option group. The values are:

1 = Small
2 = Medium
3 = Large
4 = Extra Large

A pizza can only have ONE size ... the corresponding number (1-4)
is stored for each record. The size has a range of values, but is
only equal to one of them at a time.

When someone uses the option group on the form, they can choose
only one size. The option group will have a value between 1 and 4
depending on which size is chosen. The "others" are just options
that weren't chosen, they don't really have a value because they
don't apply.

The numbers that you assign (for use by ACCESS - when they are
selected) can be anything. You can even make them all the same,
but that really defeats the purpose and doesn't present anything
useful.

Wayne

 

[samm]

thank you so much WayneRyan and Pat Hartman

you and Pat Hartman are right "Each option group stores a single value"

My form MULTI-CHOISE QUESTION for students

so I like code to store score in tabel,

when I have three groub like

G1 incloud op1 op2 op3
G2 incloud op1 op2 op3
G3 incloud op1 op2 op3
3text ( T1 T2 T3 )

each option value store in one text

please if you have that code fore store the score

regards