Show subform column total on parent form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Form Name: ACR Question Lanes
Subform Name: qryACR Question Lanes subform
Column to Sum: FeeLaneLength

I need to show the sum total of the subform's column on the form itself. I
keep getting a #Error message for both of these equations, that I've tried in
a text box:

=Sum([qryACR Question Lanes subform].[Form]![FeeLaneLength])

=DSum("[FeeLaneLength]","qryACR Question Lanes")

The query is a select query that uses criteria from another form when form
"ACR Question Lanes" is opened. The subform populates properly. I know I'm
close but I can't see the forest for the trees.

Any help from my wiser wizards will be greatly appreciated!
 
Create a field in the sub form page footer to sum the Field
=Sum([FeeLaneLength]) ' visible = false

Create a Field on the main form that refer to the field you created

= Forms![ACR Question Lanes]![qryACR Question Lanes
subform].Form![FieldSumName]
 
Back
Top