Saving and updating a calculation

[vand_uk]

Hi
I'm creating a small stock control system. I want to be able to update stock levels. Simply by entering new amounts of stock when they arrive and adjusting for stock used that day. I've created a form from a query which takes current_stock level and then I enter a value (say 50) and it is calculated (added together). Then i want to save that new value back into the current_stock field?
Can anyone help??

Thanks

 

[neileg]

You shouldn't store this value, you should caculate it from the receipts and issues. Search in these forums for stock or inventory. There's plenty of help.