Radio buttons

[Bhagya]

Hi,

I have 2 seperate Yes/No fields in my table.
In my form I have created 2 radio buttons that are bound
to these fields.

My problem is, I can click yes to both of them I tried to
group them but that does not work.

How can i make them exclusive - i.e restrict entry to just
one button

Thanks
Bhagya

 

[Neil]

Hello,

You only need 1 field in your table to hold the value of the buttons. If I
remember correctly, you make the option buttons by adding a frame control
and the wizard will do the rest (there is an option to store the value into
a field in a table for later use)...

HTH,

Neil.

 

[Bhagya]

Thanks Neil that worked perfectly - I still have one
problem

Now, when I run a query to pick the values It is showing 1
or 2.
I want it to show text. Is there any way to do this.

Thanks
Bhagya

 

[Rick Brandt]

Hi,

I have 2 seperate Yes/No fields in my table.
In my form I have created 2 radio buttons that are bound
to these fields.

My problem is, I can click yes to both of them I tried to
group them but that does not work.

How can i make them exclusive - i.e restrict entry to just
one button

You wouldn't normally set it up that way. You would use one field in the table and
store a 1 to represent the first radio button and store a 2 to represent the second
one. To configure this on the form you drop an OptionFrame onto the form and place
the Radio Buttons inside of the Frame. It is the Frame that is bound to your field
and each radio button causes the frame to acquire a different numeric value.

 

[Jen]

If you go to the radio button properties under format, you
can set the format to "yes/no".

Jen