Running Total in Form from ubform

[freefour]

Hey all,

Inside my invoice form, I have a subform where people enter in parts description, the quanity, and the parts price. I also have another field that totals quanity * price. As they are entered I am looking for a way to have a text field on the Invoice form that shows a running total of all parts charges inside the subform.

Any help would be greatly appreciated!

Thanks!

 

[PHV]

In the footer section of the continuous subform have a TextBox, say txtRunningTotal, with ControlSource set to:
=Sum([quantity] * [price])
And set the ControlSource of the textbox in your main form to:
=Me![name of subform control].Form.Controls("txtRunningTotal")
You may have to play with the ReCalc method of the form object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244