I have a stock management system and I want it so when you put through an order on a form it automatically updates the stock level. I have the correct update query and I have added a macro to the form so when you click off of the quantity field it should update the stock level. However, it keeps...