How to make a sum of a sub-form on the main form

[Patrick]

Is it possible to have a sum formula on a main form that calculates with data
from a sub-form?

I have a subform in datasheet format with several colums.
This datasheet also has the "new record" line.
On the main form I want to have a summ of each (sub-form)colum
I want to keep the sub-form in datasheet format for good reasons.
The sub-form uses a different recordsource than the main form.
The sub-forms recordsource is a dynamic query that get's updated/filtered
with settings made on the main form.
Can a formula refer to a query field?

 

[KARL DEWEY]

Use DSum on the main form for each field of the subform query.

 

[Patrick]

Thanks Karl,
Found that:
total = DSum("[field1]", [subform].[Form].[RecordSource])
did the trick.