Copying a constant from one table to another using a Toggle/Check

[Guest]

I've set up a series of Questions where each question can have one of four
answers with each question having the same four answers to choose from. I
want to use a Check Box or Toggle for each of the four answers. If the first
toggle is activated then I want to write the vaule of 0 (Zero) into a
specific field; if the second toggle is activated then I want to write the
value of 1(One) into the field and so on. How do I do that? I can't make
the "Expression Builder" work for me at all. I just don't know how to use
it.

Thanks,
Larr

 

[Steve Schapel]

Larry,

You could use an Option Group for the Answer, with 4 check boxes or
option buttons or toggle buttons within the Option Group for the 4
answer options. By default, Access will assign the values 1, 2, 3, 4 to
the options, but you can change this to 0, 1, 2, 3 by editing the Option
Value property of the toggle buttons.

 

[Guest]

Thanks Steve - I now know how to do one more thing with Access.