Inventory control form

[Guest]

I have a inventory database with a main and subform setup. The subform tracks item transactions.

There are (4) text boxes on the subform, Deduction, Addition, Quantity and Balance. The Balance box contains a formula as the control source, (([Quantity]-[Deduction]+[Addition]), and works fine.

I want to update the Quantity on the main form whenever the Balance box on the subform changes and have been unable to make this happen. I have tried numerous ways, macros, events on change etc.

Please help!

 

[Damon Heron]

First, put the Balance box in the form footer of the subform. On the main
form the Quantity textbox would use as the control source the expression:
=[yoursubform].Form!Balance

Also the Balance box expression might benefit from the NZ function.

HTH
Damon

I have a inventory database with a main and subform setup. The subform tracks item transactions.

There are (4) text boxes on the subform, Deduction, Addition, Quantity and

Balance. The Balance box contains a formula as the control source,
(([Quantity]-[Deduction]+[Addition]), and works fine.

I want to update the Quantity on the main form whenever the Balance box on

the subform changes and have been unable to make this happen. I have tried
numerous ways, macros, events on change etc.