record set not working

[aarellano]

Hello,
I am building an asp page and it works well but when I use the following expression on my record set it does not work I get the following error
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
Default.asp, line 208

Line 208 is this

Recordset1.Source = "SELECT category, item, description, price  FROM menu where category = 1 "

if I put my record set the following way it does work

Recordset1.Source = "SELECT category, item, description, price  FROM menu"

any help is appreciated

 

[aarellano]

ok so I found the answer

I needed

'" & strParm1 & "'"

thaks everybody