Please Help with Radio Buttons

February 20, 200619 yr

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, 200619 yr by Guest

February 20, 200619 yr

Hi

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

Case(

recordStatus = "Not Applicable";-99;

""

)

February 20, 200619 yr

Author

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, 200619 yr by Guest

February 20, 200619 yr

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.

February 20, 200619 yr

Author

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, 200619 yr by Guest