Update error (Access 2000)

[aral]

I am trying to convert the updtae query into a command but i get back the message that the query does not exist.What is syntax for this command ?. I am applying the attachement

[patt]

For a start you set SQL in code to the update query then try tp execute the contents of strSql which i dont think you have setup.

I dont know what you are trying to accomplish, look at productid=10, there are 2 Order Details1 records which hold 46 and 58 as the quantity. Your query will update firstly the record with 46 then the record with 58, which is correct?

[aral]

Oh yes, you are right ! Thank you for your remark, i see my error now