Populate a field

[dr223]

Hi,

I have a Subform which is build up of a FEE field, this field is populated with fee amounts from different payers. I have created a query to sum all the amounts and have a total amount.

What I want to do is that at the end of the Fee Field in the subform, display the total amount which will be read the query. Moreover, I want also if any change is made on the Fee Field, the total amount to be changed to reflect the change.

Thanks

 

[ajetrumpet]

What I want to do is that at the end of the Fee Field in the subform, display the total amount which will be read the query. Moreover, I want also if any change is made on the Fee Field, the total amount to be changed to reflect the change.

In my sample database FAQ, I have done (almost) the same thing you are talking about here. I have a subform in DS view, and on the main form, right below that subform, I have a textbox with a controlsource of the DSUM function. It sums one field in the subform recordset. Is this maybe what you're looking for??