access 2007 & VB6 "Too few parameters. Expected 1." when using a variable

[daveinarmstrong]

StoreSelected and TheSku are both variables. when i replace TheSku with 6070014 this works fine but when using the variable TheSku i get error message "Too few parameters. Expected 1."

TheSku is decaled as long and is a long number in access

thanks in advance for any help.

"select * from storeskus where storename = '" & StoreSelected & "' and ourstocknumber = TheSku "

[daveinarmstrong]

this seems to work:

"select * from storeskus where storename = '" & StoreSelected & "' and ourstocknumber = " & TheSku & " ",

[si_the_geek]

"select * from storeskus where storename = '" & StoreSelected & "' and ourstocknumber = " & TheSku  & ""

edit: hmm, I typed slow!

[daveinarmstrong]

many thanks for your reply, Si.