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
Thank You...Robert
|
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 |