Enable Disable Textbox when something from combobox is picked

[awilliams]

I placed the following code on the combobox and was trying to enable/disable a separate textbox based on the selection from the combobox and it doesn't work. For the most part, it stays disabled.

Private Sub cboErrorDetect_Change()
If cboErrorDetect.Value = "Fraud Ring Analysis" Then
txtLoss_FRA.Enabled = True
Else
txtLoss_FRA.Enabled = False

End If

End Sub

thanks!

[Allan Murphy]

In your combo box cboErrorDetect_Change how many columns is in the drop down. If there is only on column then it should work but if the combo box is bound to another column thne you will require to change your code.

Please list the columns of your combo box.

Allan

[awilliams]

1 column in the drop down. I got it to work when I put the Me!--why is that?