making text field editable

[Guest]

Hi

I've a form which consists of combo box and some text boxes. Currently, the
text boxes are not editable. I want to set these text boxes to be made
editable whenever a user selects a particular item from the combobox eg:
'Others' item from the combobox so that users can enter data into the
relevant text box fields.
Any help is appreciated. Thks.

 

[Mike]

Hi

I've a form which consists of combo box and some text boxes. Currently,
the
text boxes are not editable. I want to set these text boxes to be made
editable whenever a user selects a particular item from the combobox eg:
'Others' item from the combobox so that users can enter data into the
relevant text box fields.
Any help is appreciated. Thks.

Change the "After Update" event on the combo box so that it has code which
is something like (say combo box is called Combo1 and text box is called
TextBox1):

If me.Combo1 = "Others" Then
me.TextBox1.Enabled = true
me.TextBox1.Locked = false
end if


P.S. You might not need to change both the Locked and Enabled properties,
have a play around with it....