Hi All,
I am trying to update a field in an access table via ADO and SQL. I am getting a syntax error which I am not able to resolve. Basically, the field is updated based on the quantity in the text box and the item selected in the list box. I am getting an error message when I include the WHERE clause of the SQL statement and I don’t get any error messages when I don’t have it. So, the problem is in how I am representing the item selected in the list box. Any help appreciated.

Public objCmd As New ADODB.Command

objCmd.CommandText = "Update PO_Table Set Quantity=" & txtQty & "Where PO_number=" & "'" & lstPO.Text & "'"

Also, could you recommend any sites/books that specifically talk about SQL syntax in a VB environment.

Thanks
Zack