Search code not working

[vampyr07au]

Please Login or Register  to view this content.

When trying to search for an entry using the volume criteria which is numerical data I get a debug error on the red line of code.
The error comes up as a "data type mismatch in criteria expression" runtime error 3464

[MarvinP]

HI,

After reading your code I have concerns there may be a problem with

Please Login or Register  to view this content.

I'd set a breakpoint in my code and insure it is correct before moving forward. You may also need to do a TRIM on strCriteria to knock off the last space or two so it works.

hope this helps.

I also wonder why you use " AND " for Volumn but "*' AND " for the others but still remove exactly 5 characters?