If statement

[darinmc]

If Forms!frmSwitchboard!tPassID = 1 Or Forms!frmSwitchboard!tPassID = 8 Or Forms!frmSwitchboard!tPassID = 3 Or Forms!frmSwitchboard!tPassID = 2 Or Forms!frmSwitchboard!tPassID = 4 Then

Is there a way to write this in a LESS lengthy way?

Thx
Darin

 

[SkipVought]

Hi,

select case Forms!frmSwitchboard!tPassID 
  case 1, 8, 3, 2, 4
    'do something
end select

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}

 

[Andrzejek]

I like the Select way, but if you really want to stick with an IF statement....

If InStr("*1*8*3*2*4*", "*" & Forms!frmSwitchboard!tPassID & "*") Then
    [green]'do something[/green]
End If

Have fun.

---- Andy