Running Total

[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 parent Invoice form that shows a running total of all parts charges inside the subform.

Any help would be greatly appreciated!

Thanks!

 

[misscrf]

I would think you would set this as on tab or on exit of a field. You should be able to easily create a macro or module that will sum your required fields and display the sum in the field you want it to show up in.

Ie. if the user is in the field entering in something, they would generally tab or exit the field in some matter like that. You can set the property of that field to update a sum funtion displayed in an unbound text box.

Does that seem doable? If not, let me know and I will try to create some test data if I can.

 

[PHV]

Either take a look at the DSum function or create a running total textbox in the subform's footer section.
More explanation of the 2nd tecnique in your another post.

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