Maria Tique Posted February 20, 2006 Posted February 20, 2006 (edited) 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 Posted February 20, 2006 Posted February 20, 2006 Hi you may set the AutoEnter/Replace options of those 3 fields with this calc: Case( recordStatus = "Not Applicable";-99; "" )
Maria Tique Posted February 20, 2006 Author Posted February 20, 2006 (edited) 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 Posted February 20, 2006 Posted February 20, 2006 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 Posted February 20, 2006 Author Posted February 20, 2006 (edited) 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 Posted February 20, 2006 Posted February 20, 2006 Ok Try this... but I think that you'll need more... RadioButtons.zip
Maria Tique Posted February 21, 2006 Author Posted February 21, 2006 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
Recommended Posts
This topic is 6867 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now