Hello again Experts,
I am trying to create an update query (see code below) that take information of the open form and updates my table. I believe the code is self explanatory. It takes the MMS# and and finds it in the table then it should take the OnHand value and minus the Qty1 and update the OnHand value to the new value. Whenever i run this query it keeps asking me for the values (cant find Qty1, etc).
Thanks for the help,
UPDATE tblPaperCost SET tblPaperCost.OnHandQty = [OnHandQty]-[Forms]![WHReq].[Form]![Qty1]