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

P

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?
 
P

Patrick

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main form sum from sub form 0
Access Sub form opens before the main form in MS Access 0
Update subform with combobox change on main form 1
Use a button to filter a sub subform 2
Main form with two sub forms 1
Trouble Filtering a Sub Form With Combo Box Options 2
Show calculation from main form in sub form 2
Filtering a main form based on a sub-form 6

Top