Brilliant, THis is what is appearring in immediate window:
UPDATE Tbl_SalesOrderDetails SET Delivered_Qty = 2,000 WHERE SalesDetails_ID=179
oh i should have said i streamlined the code a bit to the following:
Dim codeissue As String
codeissue = "UPDATE Tbl_SalesOrderDetails SET...