Option buttons

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

Guest

I have a form with 4 option buttons within an option group. These buttons are
not saved in any field at the present time. If I choose 1 it follows through
to the next record, if I change it it changes all records. How can I get this
not to change? Also if I want to save this to a field in a table as yes/no
what would I need to do if more than one is chosen?
 
I have a form with 4 option buttons within an option group. These buttons are
not saved in any field at the present time. If I choose 1 it follows through
to the next record, if I change it it changes all records. How can I get this
not to change? Also if I want to save this to a field in a table as yes/no
what would I need to do if more than one is chosen?
Click to expand...

You have to save the value in a table and it cannot be a Yes/No field.
A Yes/No field can only store a -1 or a 0 value.
An Option Group's value is 1, 2, 3, 4, etc. depending upon how many
options are in the group.
Add a Number datatype field, Integer field size, to your table.
Set the Option Group Control Source to this field.
 
Back
Top