more than one if statement

[scottappleford]

Hi

I would like to specify more than one criteria of an if statement.

e.g, if = ? then ?
but i would like to add more critreria as i have more than one selection in my combo box.

Thanks in advance

 

[spacepro]

You could write the code something like

If me.field = 1 Then
'Do something
ElseIf
me.field = 2 then
'Do something
End If
End if

or you could use a select case statement

Select case me.field
Case >= 1
'do something
Case>= 2
'do something
Case >= 3
'Do something
End Select

Hope this Helps
Andy

 

[spacepro]

Thanks Pat,

It's been a long day.

Andy