Please Help with Radio Buttons

[Maria Tique]

Pleae Help!!!

I have 4 fields.

The first field is called record status and it is a radio button with 3 values: Entered, Missing, and Not Applicable.

The other 3 fields are called ps1, ps2, and ps3 and they are all radio buttons with the following values: 1, 2, 3, -89, and -99

QUESTION: Where do i code and how do code so that if record status is checked Not Applicable then ps1, ps2, and ps3 will have the -99 radio button checked for all 3 fields?

Edited February 20, 2006 by Guest

[Raybaudi]

Hi

you may set the AutoEnter/Replace options of those 3 fields with this calc:

Case(

recordStatus = "Not Applicable";-99;

""

)

[Maria Tique]

Thank you for your reply.

So in other words, i would set this calc in the ps1, ps2, and ps3 fields as a calculation? It is not working. Please forgive me but i forgot to add to my previous question how to program if the user checks Missing in the recordstatus then ps1, ps2, ps3 fields would have the -89 radio button checked.

Edited February 20, 2006 by Guest

[Raybaudi]

So the calc becomes:

Case(

recordStatus = "Not Applicable";-99;

recordStatus = "Missing";-89;

""

)

And it must work...but you have to remember to uncheck the box with "Do not replace existing value" when you have finished to enter this calc into the AutoEnter option of those fields.

[Maria Tique]

Hello. Thanks, and you are most certainly correct, it does work!!!!Great, but if the user enters in the recordstatus the value "missing" then ps1, ps2, and ps3 should ONLY have a value of "-89" and not let the user change ps1, ps2,or ps3 to have any other value other than "-89". Currently it is allowing a user to enter into ps1, ps2, ps3 a value of 1, 2, or 3 even if record status is checked as "Missing". How can i stop this?

Edited February 20, 2006 by Guest

[Raybaudi]

Ok

Try this...

but I think that you'll need more...

RadioButtons.zip

[Raybaudi]

or try this one...

RadioButtons.zip

[Maria Tique]

Oh Thank you so much. I really really appreciate it. I am new to FM and love it but get nervous sometimes because i have deadlines to meet.

Thank you this is perfect and awesome. I was so worried. Thank you a million