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