Radio Buttons in Form

[Eric Dropps]

Hello,

Is their any way to use a radio button that will hold a value from a field
in a form? kind hard to explain but I will try to show my form:

Header
----------
[goto form A] [goto form B] [goto form C]

Data from query
----------------------------------
() Row A Data
() Row B Data
() Row C Data

Footer
-----------------
[exit]


I would like to be able to select one of the radio buttons () on a
record/row and then press one of the top buttons to go to a particular form
(the record is selected using the PK that the radio button represents)

When I make it, the buttons are either all on or off, or it tries to
actually change the PK to Zero when I unselect....

Thanks!

-Eric Dropps

 

[Tim Ferguson]

Is their any way to use a radio button that will hold a value from a
field in a form? kind hard to explain but I will try to show my form:

You need an option group: set the control source of the option group to the
correct field; embed as many radio buttons as you need inside it; and set
each of their Value properties to the correct number. Warning: an option
group only returns a numeric value (or Null, if you allow it), so it has to
be attached to a numeric (i.e. Integer) field, not text or boolean. If you
need a text field, then you are into VBA tricks or a list box.

It's all in the help files: look up Option Groups.

Best wishes


Tim F