Hi, I'm trying to put a value from subform's textbox B to form's textbox A when form is about to close.
The main form is based on Order table, subform is based on Order_Detail, Order_Detail has a textbox Subtotal in its footer =Sum(EachPrice)
Order table has a field sum, which is a textbox in main form. I would like to do something like this:
When main form is about to close (OnClose event)
For each Order
Order.sum = Order_Detail.Subtotal
Next Order
Pls don't ask me why I would do this, why not make it for a afterupdate event on Subtotal etc. I have been asked to do something like this, not others.
Thanks every much for any help and idea.