Disable Text Boxes

N

Nick1966

Hi

I have a form on which to enter data, but to improve data entry accuracy I
want to disable some fields depending on the values entered in other
fields.For example the first field is ComboBoxA if Option1 is chosen then
TextBox1 is available for data input, if Option2 is chosen then TextBox1 is
not available for data entry.

I hope this is clear.

Thanks

Nick
 
O

Ofer

On the after update event of the combo insert the code
If Me.ComboName = Option1 Then
me.TextBox1.enabled=True
else
me.TextBox1.enabled=False
End if
 
Top