Field Greying

[rmdrye]

I would like a field to be accessible only if specific selections are made from the previous combo box. Could someone help me with the code for this?
Thank You...Robert

 

[Emohawk]

In the After Update event of you combo box put this.

If My_Combo = "Some_Value" then

My_Field.Locked = True
My_Field.ForeColor = 0 'Whichever colour for grey

else

My_Field.Locked = False
My_Field.ForeColor = 0 'Whichever colour for black

End If

HTH

 

[David R]

You may also want to use the Current event if this is going to have to be true in existing records too when you page through them.

David R