Enable toggle boxes depending on input

[mpsDA]

Im creating a result sheet for exams. I would like a toggle with PASS on it, to be automatically selected if the pass mark is 90% or above and FAIL if below 90%

 

[GingerR]

Hi. What have you already tried? How is "pass mark" calculated? Is it just in a single field, or is it a calculation that's done on-the-fly? For "toggle" do you mean a simple check box which is checked if PASS and not checked if FAIL? Please give more details.

=iif(Result >= .9,True,False)


Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[mpsDA]

The pass mark is manually entered. The toggle box is seperate to entering the results. I was wondering if they can work together. When a result is entered the toggle box will either be PASS or FAIL. If not a Toggle box what would you suggest. I would like PASS or FAIL to be enabled somehow for the user to see.

 

[GingerR]

You could have a text box, and for the control source put:

=iif(txtResult >= .9, "PASS", "FAIL")

replace "txtResult" with the name of the control that has the result in it. This will show a word of PASS or FAIL. How's that?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[mpsDA]

where exactly to I enter the following code??
=if(txtResult >= .9, "PASS", "FAIL")

Is it in the Validation Rule. Cann you point me to the right direction please.

 

[GingerR]

in a new text box on your form. You could also put it in a query. What exactly are you working on? Since this is the FORMS forum, I assumed you're working on a form.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html