Add Subtotals from subform to main form

[tweety]

hi



i have attached a image of a form which is not working out the totals for me. the way id like it to work is the sub totals are totaled (from sub form 13.20 + 13.20) is done using a hidden text field in the same sub form. the hidden text that be should displayed in the main form (i.e text 22)

the problem is it works when you set it to workout the quantity but not the sub totals. i have formmated it to number and removed the £ sign too, that didnt work. the one thing i noted is the sub total is just a text box and not a field in table.

is that the problem? thanks in advance

[June7]

This is a form/subform/subsubform arrangement? Looks like the total is on the subform. What is the expression used in the textbox?

An alternative is to show the totals at the bottom of the continuous/datasheet subsubform. With the forms open normally, click into the subsubform and click the Totals button on ribbon. This will open a row at bottom of the records where you can select aggregate function for each column. Then save the form. Cannot reference these totals because they are not in textboxes.

[tweety]

hi thanks for getting back, yes the form is a form/subform/subsubform arrangement

iv copied the setup from http://www.databasedev.co.uk/subform-total.html

so i have the totals buying price in a hidden text box in the subform footer and then text 22 just displays that value.

i cant get the quantity and buying price to read but not the sub totals? is it because its not stored it a table?

i cant seem to find the tools? which one is it under?

[June7]

Ribbon > Home > Records > Totals

Think should be able to reference that textbox even though the sum is based on calculated subtotals. I just don't have any db with this structure but seems I have helped other posters with this and it worked.