Footers in a subform?

[brich]

1. I can't seem to 'turn on ' the footer in a Subform. I can turn on headers and footers in the subform properties, but when view in 'form view', the footer is not visible?
2. Is this a way to show a total of one of the fields in the subform?
brich

[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.

[brich]

Thanks, Option 1 works just fine.
brich

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.