Assigning the value of a calculated field on a form to a table fie

[Guest]

I have a Inventory table and other table with Inventory transactions. I desiged a form for the Inventory table and a subform for the transactions. On the subform I create a calculated field for the Quantity on Hand and now I want to put that value on the Inventory Table ¿How I can do that?

 

[Allen Browne]

This article explains when and how to save your calculated field:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

For an alternative approach where the quantity is calculated when needed
instead of stored in your table, see:
Inventory Control - Quantity On Hand
at:
http://allenbrowne.com/AppInventory.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a Inventory table and other table with Inventory transactions. I

desiged a form for the Inventory table and a subform for the transactions.
On the subform I create a calculated field for the Quantity on Hand and now
I want to put that value on the Inventory Table ¿How I can do that?