Ill try and explain this as best I can.

I have a form with a subform, the subform contains all the data, the main 
form is used as a connection link.

On the subform I want to create a cumulative total specific to the project 
and department according to month so essentially I want something like:

(Main Form: Frm_Edit Department Detailed)
Project: A
Department: 0004

(Main Form: Frm_Edit Department Sub)
Month     Planned     Cumulative
June          342            342
Jul             123            465
Aug           456            921


At the moment I have the following as the control source for cumulative but 
it doesnt seem to like it I just get #error

=DSum("[Planned]","[Tbl_Department Detailed]","Month <= [Forms]![Frm_Edit 
Department Sub]![Month] AND [Project Number] = [Forms]![Frm_Edit Department 
Detailed] ANd Discipline=[Forms]![Frm_Edit Department Detailed]!Discipline")



-- 
Thank you in advance

Have you tried using that code in a query and basing the subform on that? 
Then you can make it read only and the fields will be updated.

I am wondering whether you have the speech marks in the wrong place. The 
following works in a very simple query.

 DSum("[cost]","[table1]","rec<=" & [rec])

-- 
www.ae911truth.org



"andrew3254" wrote:

> Ill try and explain this as best I can.
> 
> I have a form with a subform, the subform contains all the data, the main 
> form is used as a connection link.
> 
> On the subform I want to create a cumulative total specific to the project 
> and department according to month so essentially I want something like:
> 
> (Main Form: Frm_Edit Department Detailed)
> Project: A
> Department: 0004
> 
> (Main Form: Frm_Edit Department Sub)
> Month     Planned     Cumulative
> June          342            342
> Jul             123            465
> Aug           456            921
> 
> 
> At the moment I have the following as the control source for cumulative but 
> it doesnt seem to like it I just get #error
> 
> =DSum("[Planned]","[Tbl_Department Detailed]","Month <= [Forms]![Frm_Edit 
> Department Sub]![Month] AND [Project Number] = [Forms]![Frm_Edit Department 
> Detailed] ANd Discipline=[Forms]![Frm_Edit Department Detailed]!Discipline")
> 
> 
> 
> -- 
> Thank you in advance
> 
> 

-- 
Thank you




"scubadiver" wrote:

> 
> Have you tried using that code in a query and basing the subform on that? 
> Then you can make it read only and the fields will be updated.
> 
> I am wondering whether you have the speech marks in the wrong place. The 
> following works in a very simple query.
> 
>  DSum("[cost]","[table1]","rec<=" & [rec])
> 
> -- 
> www.ae911truth.org
> 
> 
> 
> "andrew3254" wrote:
> 
> > Ill try and explain this as best I can.
> > 
> > I have a form with a subform, the subform contains all the data, the main 
> > form is used as a connection link.
> > 
> > On the subform I want to create a cumulative total specific to the project 
> > and department according to month so essentially I want something like:
> > 
> > (Main Form: Frm_Edit Department Detailed)
> > Project: A
> > Department: 0004
> > 
> > (Main Form: Frm_Edit Department Sub)
> > Month     Planned     Cumulative
> > June          342            342
> > Jul             123            465
> > Aug           456            921
> > 
> > 
> > At the moment I have the following as the control source for cumulative but 
> > it doesnt seem to like it I just get #error
> > 
> > =DSum("[Planned]","[Tbl_Department Detailed]","Month <= [Forms]![Frm_Edit 
> > Department Sub]![Month] AND [Project Number] = [Forms]![Frm_Edit Department 
> > Detailed] ANd Discipline=[Forms]![Frm_Edit Department Detailed]!Discipline")
> > 
> > 
> > 
> > -- 
> > Thank you in advance
> > 
> >