Originally Posted by
June7
Is the form set for Datasheet view? Headers and footer will not show.
Options:
1. if subform is set for Datasheet view, while open in form (not design) view, click the subform then click the Totals button on the ribbon. This will open a totals row at bottom of subform. Select Sum from the dropdown list below the column you want to sum.
2. a textbox in form header/footer with expression: =Sum([fieldname]) and it will show in Continuous or Single view; for Datasheet view a textbox on main form can reference the subform textbox.