I have written and run an update query in Northwind. It updates the unitsinstock field of the products table. What I want to do is update this field based on the qty ordered in a specific order not every order. Eg. I have 10 products in stock, someone orders 3 - this gives me 7 in stock after I run the update query. Another order wants 3 of the same product and after running the query again, it subtracts these 3 products AND the previous 3 again leaving me with 1 product when I should actually have 4. :mad: How can I attach this query to the orders form so it only runs according that particular order and not all previous orders? Thanks