Expected: expression

[irade92]

In this simple line of code:
If Left(mOsig, 4) Not In("4834", "4835", "4836", "4837") Then


i got this message: Expected: expression and cursor locate at In..and cannot go anyfurther..What is the problem

I have seen similar example in the books and seems everything is ok..
Please any idea

 

[pbaldy]

To my knowledge you can't use IN() in VBA; it's only in JET SQL. You'd have to do individual comparisons.

 

[vbaInet]

This was recently discussed here. It shows how one can use the IN() keyword in VBA and other alternatives.

http://www.access-programmers.co.uk/forums/showthread.php?t=219298