"Syntax error in from statement" while using SQL in VB6

[joeconway]

i have a very simple couple of lines of code:

sql = "SELECT Itemid FROM [tblstock]; WHERE itemid = txtitemid.text"
adostock.RecordSource = sql
adostock.Refresh


and i keep getting the error in the subject line. I really can't understand the problem because i don't see what else i could put in.

any help would be really appreciated

 

[gmmastros]

sql = "SELECT Itemid FROM [tblstock] WHERE itemid = " & txtitemid.text

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[mattKnight]

As a hint for the future

sql = "SELECT Itemid FROM [tblstock]; WHERE itemid = txtitemid.text"
[COLOR=red]Debug.Print sql[/color]
adostock.RecordSource = sql
adostock.Refresh

Would have quickly shown you where the error lay! (I virtually always do this when building SQL dynamically to make sure the the SQL string is built properly)

Take Care

Matt
If at first you don't succeed, skydiving is not for you.