Shade text box based on value of another field?

[Guest]

I have a form with test results and a form for attendance. I would like to
disable text boxes on the attendance form if a corresponding field in test
results is over a certain value. (for example, if a student scores over a 70
in Section1 of the curriculum, he does not have to attend the class, so i
would like the text box for Section1 attendance to be disabled)
anybody out there who can help me with this?
(i am an amateur, so please be specific)

 

[Alessandro Baraldi]

f2rox ha scritto:

I have a form with test results and a form for attendance. I would like to
disable text boxes on the attendance form if a corresponding field in test
results is over a certain value. (for example, if a student scores over a 70
in Section1 of the curriculum, he does not have to attend the class, so i
would like the text box for Section1 attendance to be disabled)
anybody out there who can help me with this?
(i am an amateur, so please be specific)

If you are on a SingleView Form you need to use Current Form Event's.

Private Sub Form_Current()
Me!txtToDisable.Enabled=Me!txtScore<70
End Sub

@Alex