Get the total sum from subform to main form

[Willie05]

Can anybody please help me on how to get the total sum from subform to main form.

Eg, i have a list of sale amount for each product sale in the subform and i want to get the total of this sale and place it in the mainform.

Thanks for the help

 

[Rich]

Add a textbox to the subform footer calculate the sum there, add a text box to the main form and set the control source to the subform footer field.

 

[Willie05]

I already did that, but it come out with "#Name?" on the textfield.

 

[DBL]

You need to reference the subform as:

=Nz([SubformName].Form![FieldName],0)

The Nz just returns a value of £0.00 if the subform field is blank.

Check the "Name" property for the subform and the field, that's what you should go in the [FieldName]