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 "