enable/disable text box based on 3 combos

[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

 

[Linq Adams via AccessMonster.com]

Text is a Reserved Word in Access and is, in fact, the name of a textbox
property, and

Me.Text.Enabled = True

may confusing the Access gnomes! I'd modify the name of the textbox.

Also, your code for thee third combobox is

If Me.Combo3 = "NO" Then
Me.Text = True

and I expect you mean it to be like the rest

If Me.Combo3 = "NO" Then
Me.Text.Enabled = True

 

[John W. Vinson]

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

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.