Search Engine in Access using VBA

[Arthurr]

I have an Access database linked from SQL server and I need to create a search engine using VBA.

I managed to create search engine for varchar items, but I cant make it to search numbers as well.
I have a table called Product, with a field Product-ID.
The field defined as Int and all the data is sequential numbers from 1 and on.
How can I alter the statement:
[Product Name] LIKE '%" & search & "%'
so it will search from [Product-ID] ?

Thanks a lot

[NeoPa]

First off, you lose the single-quotes ('), as these denote string data.

That said, LIKE is not valid for numerical data. You can use :

[Product-ID]=X

With variations on the "=" of "<>", ">", "<", ">=", "<=", etc.
You can also use :

[Product-ID] In(X,Y,Z)

or :

[Product-ID]=Between X And Y