If...ElseIf...Then Statement

[Guest]

Having a problem getting an If...ElseIf...Then statement to work. I have:

If ([Control 2] >399) And ([Control 2] < 5001) Then
Do This

ElseIf ([Control 1] = "xxx") And ([Control 2] > 399) And ([Control 2] <
5001) Then
Do This

Else
Do This

End If

 

[Bill Edwards]

Using that logic the do this stuff code for:

ElseIf ([Control 1] = "xxx") And ([Control 2] > 399) And ([Control 2] <
5001)

will never execute

 

[fredg]

Having a problem getting an If...ElseIf...Then statement to work. I have:

If ([Control 2] >399) And ([Control 2] < 5001) Then
Do This

ElseIf ([Control 1] = "xxx") And ([Control 2] > 399) And ([Control 2] <
5001) Then
Do This

Else
Do This

End If

You also need to check if [Control] is not "xxx", otherwise you will
never get to the ElseIf.
Also notice the different parenthesis placement.

If [Control 1] <> "xxx" And ([Control 2] > 399 And [Control 2] <
5001) Then
Do this thing
ElseIf [Control 1] = "xxx" And ([Control 2] > 399 And [Control 2] <
5001) Then
Do this other thing
Else
Do that
End IF

 

[George Nicholson]

If ([Control 2] >399) And ([Control 2] < 5001) Then
If ([Control 1] = "xxx") then
'What was your 2nd "Do This"
Else
'What was your 1st "Do This"
End If
Else
Do This
End If

HTH,