Subform problem

[Charlie2]

Im trying to calculate the totals in a text box on my subform using this syntax, =sum([Amount]) the trouble is the text box remains blank, could someone take a look please.
http://homepage.ntlworld.com/charlie_chuck/invoice12.mdb

The subform is part of frmInvoiceSubformsupplier.

Thanks

Charlie

 

[Ally]

Your syntax is right, but you've got the textbox outside of the subform. The field value [Amount] means nothing to it as the main form doesn't have a field called [Amount]. The way to normally subtotal a subform, would be within the subform.

To do it within the subform you need to make the subform a "continuous form" - (you'll need to rearrange a few bits on this putting all the title boxes in the header section in one line across the page and keeping all the fields in the detail section, but arranging in a line across the page).

Then, in the footer add a text box with your =Sum([Amount]).