And Or Syntax (1 Viewer)

[Novice1]

The following If Then statement doesn't work. Am I using the And's and Or's correctly?


If (Me.CurrentSGLIAmt <> "400,000" Or Me.RSN_Increase_Amt <> "9") And Me.UBLCombo = "Married" Then

Me.SpouseLetter = -1

Else

Me.SpouseLetter = 0

End If

 

[pbaldy]

Well, when you use <> rather than =, the logic flips. Everything is either not equal to x or not equal to y. In other words, you want And in there rather than Or.

 

[plog]

The following If Then statement doesn't work

There's a difference between working and producing unexpected results. If pbadly's advice didn't help, I suggest you provide us with examples--tell us what the 3 values are then tell us what you expect as a result of that code.

 

[Novice1]

PBaldy ... thanks ... that did it

 

[pbaldy]

Happy to help!