[RESOLVED] If statement with multiple possible values

[jre1229]

Is this not the correct way to do this? I get an error with it but if I change it to only one value then it works.

If dt2.Rows(0)("STATUS") = "COMP" Or "CLOSE" Or "CAN" Or "INCOMP" Or "WAPPR" Then
dt.Rows(currentRow).Delete()
End If

[Hack]

If dt2.Rows(0)("STATUS") = "COMP" _
Or dt2.Rows(0)("STATUS") = "CLOSE" _
Or dt2.Rows(0)("STATUS") = "CAN" _
Or dt2.Rows(0)("STATUS") = "INCOMP" _
Or dt2.Rows(0)("STATUS") = "WAPPR" Then

[David Anton]

Select Case dt2.Rows(0)("STATUS")
Case "COMP", "CLOSE", "CAN", "INCOMP", "WAPPR"
	dt.Rows(currentRow).Delete()
End Select

[jre1229]

This is what I used and it works great. David, yours would have worked too but I used Hack's version because I like for my code to flow like his example.

If dt2.Rows(0)("STATUS") = "COMP" _
Or dt2.Rows(0)("STATUS") = "CLOSE" _
Or dt2.Rows(0)("STATUS") = "CAN" _
Or dt2.Rows(0)("STATUS") = "INCOMP" _
Or dt2.Rows(0)("STATUS") = "WAPPR" Then

[David Anton]

You might want to change those Or's to OrElse.

[jre1229]

You might want to change those Or's to OrElse.

Great catch!