Option buttons on form

[fred]

We have three option buttons in an option group with default values 1,2,3 on
a form. How do we put the chosen value into the appropriate field of an
existing table?

 

[Neil]

Fred,

If you place a frame on the form (this should and may have been done
already) and place the option buttons directly onto the frame (the wizard
does this automatically for you), you can then set the field name from the
table as the control source for the frame. This will store either 1,2,3 in
the table depending on the selection.

HTH,

Neil.

 

[Steve Schapel]

Fred,

In a nutshell... Bind the form to the table (set the table as the
form's record source), and bind the option group to the field (set the
field as the control source of the option group).

- Steve Schapel, Microsoft Access MVP