Update table from vba on loop

[twmr2000]

I have a table named tblItems with a field "Qty"


I have another table, tblItemsSold, with fields "InvNo" for invoices number and "QtySold"
Both have UPC (barcode) fields.

What I need to do is when the "Complete" button is clicked:
All the Items (by UPC) with the same invoice number (InvNo) need to subtract the "QtySold" in tblItemsSold from "Qty" in tblItems.

I would like to do this through VBA so I can just plug it into the existing code I have.

I am rushed typing this ATM, so sorry if I left anything out that may make this confusing.

[JoeM]

I would recommend just creating an Update Query that does this. You can call (open & run) the Update Query from your VBA code with the OpenQuery command (see: http://msdn.microsoft.com/en-us/libr.../ff192746.aspx).

[twmr2000]

I'm sorry, but do you have an example? I'm having trouble implementing this.

[JoeM]

Which part are you having trouble with?
Do you know how to create an Update Query?
If not, see here: http://office.microsoft.com/en-us/ac...010076527.aspx

[twmr2000]

Scanning through the link you posted looks like maybe what I am after. When I have more time later I will give it a shot. Thanks. I will let you know.