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

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.

Code:

---

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

---

this seems to work:

Code:

---

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

---

Code:

---

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

---

edit: hmm, I typed slow!

many thanks for your reply, Si.