This line of code works fine:
dbs.Execute "UPDATE tblStockInventory SET Used = false WHERE ID = 22"
This line of code gives me this error : Runtime error 3075 Syntax error missing operator in query expression 'ID='
dbs.Execute "UPDATE tblStockInventory SET Used = false WHERE ID = " & txtStockItemId.Value
what am i doing wrong?
txtStockItemId is a control on my form