If Then Problem

[Novice1]

I cannot seem to get this code to work. I've tried OR instead of AND. Am I using the parentheses incorrectly?

If Me.UBLCombo = "MarriedChildren" And (Me.Primary1Relationship <> "Spouse" And Me.Primary1Relationship <> "Child" And Me.Primary1Relationship <> "Stepchild")

Then

Me.Primary1UB = -1
Me.SpouseLetter = -1

Else

Me.Primary1UB = 0

 

[Ranman256]

And is correct.
Try putting the entire IF in parenthesis....

If (clause) then

 

[plog]

I cannot seem to get this code to work

Tell us how you know its not working---error message, unexpected results?

With that said, did you leave off some of the code? I don't see an End If

 

[Novice1]

I tried adding the parenthesis to include the whole statement (without the inside parenthesis and with the inside parentheses), no luck

 

[Minty]

Write down in English what you think your If statement is testing for.

 

[Novice1]

If UBLCombo equals "MarriedChildren" and Primary1Relationship doesn't equals "Spouse" or "Child" or "Stepchild" Then Primary1UB equals Yes (checkmark)

 

[Novice1]

In response to Plog. The code is part of a nested If/Then statement (I didn't include all the If/Then statement). Everything responds as expected except when I combine then statements (Primary1Relationship <>). I get no result (no error) but fields don't update either, which is why I thought the <> statements are written incorrectly.

 

[kevlray]

I am not sure if your logic is correct.

The (Me.Primary1Relationship <> "Spouse" And Me.Primary1Relationship <> "Child" And Me.Primary1Relationship <> "Stepchild") will never be true if the Primary1Relationship is ever Spouse or Child or Stepchild. I think what you want is (Me.Primary1Relationship= "Spouse" OR And Me.Primary1Relationship = "Child" OR Me.Primary1Relationship = "Stepchild")