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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top