small code problem - IF statement

  • Thread starter Thread starter Lee-Anne Waters via AccessMonster.com
  • Start date Start date
L

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
 
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.
 
thank you thank you thank you.

that's exactly what i wanted
 
Back
Top