enable/disable text box based on 3 combos

  • Thread starter Thread starter Mikhail Bogorad
  • Start date Start date
M

Mikhail Bogorad

hi
i have 3 combos (user chooses Yes or No from a drop down) and a text
field that is disabled by default and i'm trying to enable if either
one of these 3 combos has "NO" value.

So here is what i have and it's not working so far.

Private Sub Form_current()
If Me.Combo1 = "NO" Then
Me.Text.Enabled = True
Else
If Me.Combo2 = "NO" Then
Me.Text.Enabled = True
Else
If Me.Combo3 = "NO" Then
Me.Text = True
Else
Me.Text.Enabled = False
End If
End If
End If

End Sub

Any suggestions?
Thanks
 
hi
i have 3 combos (user chooses Yes or No from a drop down) and a text
field that is disabled by default and i'm trying to enable if either
one of these 3 combos has "NO" value.

So here is what i have and it's not working so far.

Private Sub Form_current()
If Me.Combo1 = "NO" Then
Me.Text.Enabled = True
Else
If Me.Combo2 = "NO" Then
Me.Text.Enabled = True
Else
If Me.Combo3 = "NO" Then
Me.Text = True
Else
Me.Text.Enabled = False
End If
End If
End If

End Sub

Any suggestions?
Thanks
Click to expand...

A single line will do it:

Me.Text.Enabled = (Me.Combo1 = "NO" OR Me.Combo2 = "NO" OR Me.Combo3 = "NO")

Either your code or mine assumes that the *bound column* of the combo contains
the text string NO; if the combo has a concealed numeric ID field as the bound
column (which the wizard will probably generate for you) you'll need to either
test for that numeric value or use the combo's Column() property to select the
correct column. It's zero based so Me.Combo2.Column(1) would be the second
column.
 
Back
Top