Find the sum of fields on a subform

[bri822]

In my project, I have a form which contains a repetitive subform. The subform is very simple, it contains a date and a quantity(number). My problem is, I need to try to find some way to sum the quantities of the subforms, and have it on the main form.

The form is used in editing the quantities, and the sum is really to tell the user how close they are to the total they need to match. My boss also wanted to see if I could do it in real time, ie. once a user enters the number, the total is automatically updated.

I have not been able to figure out how to find the sum, and I have no clue on how to do the real time thing or if it can be done. Any help on this would be greatly appreciated. Thank you,

Brian

 

[Alexandre]

Please, provide your email, and I'll forward you a sample DB.

 

[bri822]

Thank you very much for the offer, but I got it taken care of. I searched again through some older posts and found something that helped. Just incase anyone has the same problem, the solution is not that bad. You need to add a text box in the form footer, and set that =Sum([field]) and it gives you the running sum. Then if you need to have the sum on a main form, all you need to do is simply reference the field you just made in the subform footer.

This board is great and I am not sure what I would do without, thanks!

Brian