Update a control in the main form with the Sum of the values from Subform

L

Ladi

Dear friends and Pros

I'm trying to update a control in the main form with the Sum of the values
in the subform containing columns with numbers.
There is already the relationship between main table and child table, also
between the main form and sub.
The following function would update only one control on the first record.
I have Tables:
MainTab
ChildTabName
Forms:
FormName
SubformName
-------------------------------------------------
Form_ControlName= DSum("[ChildTabName]![ColName]", "ChildTabName",
"[MainID]=[ChildTabName]![MainTabID] And [ChildTabName]![ChildTabID]=
[SubformName].Form![ChildTabID] ")

Thanks in advance,
Ladi
 

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

Update controls on main form from on changed values of the sub 1
Update records in subform with value from main form 4
Referencing Subform Control on Main Form 2
Main Form / Subform Totals 3
Transfer A value from a subform to the form 2
Retrieve a value from an unbound control on a subform 4
Label Caption on Subform from Textbox Value on Main Form 2
Confusion with forms and related subforms 3

Top