Getting a Subtotal from columns in a Subform

[dweekley]

I have been youtubing and what not but can not seem to get a textbox to provide a sub total of a column in my subform. Either error or #name keep coming up and this is when I use the expression builder.



I can however use dlookup to get the results from a query I created and this seems to be working fine. The issue is getting the query to re-query after a change has been made to a value or swtching to a different record.

[June7]

Do you mean the columns that are calculated values? Aggregate functions can only reference fields, not controls. The Sum() expression must repeat the same calc, like: =Sum([Su Hrs] * [Su Cost])

[dweekley]

No. A sum of the Entry values themselves. No calculations. So basically getting a total of all the entries in SU Hrs, SU Cost, etc.

I actually have it working that when the record (row) changes the subtotals update. Was hoping it can be done when a value in a textbox is changed. A little more immediate.

[June7]

The changed value must be committed to table before the calc will update.

Date is committed when: 1. closing table/query/form, 2. move to another record, 3 run code.