Inventory control form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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

Tkshipshape said:
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
Click to expand...
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
Click to expand...
the subform changes and have been unable to make this happen. I have tried
numerous ways, macros, events on change etc.
 
Back
Top