Options should apply to one record- not all

[blondtraillite]

For example, in a database of outstanding issues I created the option buttons
in the design form (option buttons are where you have the circles where one
can be selected and not the others).

I need to have this information for each individual issue, or record as
Access calls it. However, when I click the buttons, it applies to all of the
records, not just the one I intend it to apply.

How do I change that?

 

[Rick B]

Do these buttons correspond to fields in your table? Are they linked to
those fields? Access can't remember (store) the value if you don't have
that value tied to a field in a table.

An unbound field will have the same value no matter which record you look
at.

Rick B

 

[John Vinson]

For example, in a database of outstanding issues I created the option buttons
in the design form (option buttons are where you have the circles where one
can be selected and not the others).

I need to have this information for each individual issue, or record as
Access calls it. However, when I click the buttons, it applies to all of the
records, not just the one I intend it to apply.

How do I change that?

It sounds like your Option Group control on the form is unbound - i.e.
its Control Source property is blank. If you want it to apply to each
record, you must have a Number (integer or long integer) field in the
table, and the option group control needs to be bound to that field.

John W. Vinson[MVP]