Need to sum a feild on a subform, and pass it to a from field

[attrofy]

I have a subform with a field named Amount. I want the user to enter as many records as needed on the subform and then have it total the amount on the main form in a field called CreditAmount. I need this to update everytime an amount is added or changed in the subform. I don't know how to add unlimited entries in the Amount field of the subform. Any help is appreciated.

Russell

 

[dynamictiger]

To add unlimited records in a subform use datasheet view.

My approach to totalling is not very nice, but showuld work.

Createa query based on the sub form to total the amounts as they change.

Make another sub form based on the query. USe this on your form to total as you go.

On the onchange event otf the query subform update the main form.

 

[attrofy]

hmmmmm...I already have 4 subforms on this one form, guess onemore can't hurt.....Not sure how to run a dynamic query - which it sounds like what you are suggesting. Not quite sure I follow everything here.

If I have my orginal subform (sbfARWriteoff) and have the query Sum all the entries in the field "Amount", then create basically a one box form (called sbfAmount) that has a text box to put this info. Then I assume in the OnChange event of the sbfAmount put some event like:

[Amount]=Form!MainFormName![CreditAmount]
Me.Refresh

Two points of confusion; How do I get the query to update automatically, and what is the correct syntax of passing the subform field's value to the mainform????

Thanks for the help

 

[dynamictiger]

I am sure there is a better way to do this. I'll sleep on it and let you know.