small code problem - IF statement

microsoft.public.access.gettingstarted

25 Feb 2005 6:35 AM

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

--
Message posted via http://www.accessmonster.com

25 Feb 2005 6:49 AM

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.

--
Steve Schapel, Microsoft Access MVP

Lee-Anne Waters via AccessMonster.com wrote:

Show quote

> 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
>

25 Feb 2005 7:03 AM

Lee-Anne Waters via AccessMonster.com

thank you thank you thank you.

that's exactly what i wanted

--
Message posted via http://www.accessmonster.com