View Full Version : Field Greying


rmdrye
01-04-2002, 12:03 AM
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
01-04-2002, 07:54 AM
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
01-04-2002, 02:46 PM
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