small code problem - IF statement

[Lee-Anne Waters via AccessMonster.com]

Hi,

would someone please help with this. i cant get it to work....

if me.AuditSelectNum > "150" & < "280" then
MsgBox "Test"
End If


many thanks
Lee-Anne

 

[Steve Schapel]

Lee-Anne,

Not really sure what you want. Maybe it's one of these...

If Me.AuditSelectNum > 150 And Me.AuditSelectNum < 280 Then
MsgBox "Test"
End If

If Me.AuditSelectNum Between 150 And 280 Then
MsgBox "Test"
End If

I am assuming AuditSelectNum is a numerical data type.

 

[Lee-Anne Waters via AccessMonster.com]

thank you thank you thank you.

that's exactly what i wanted