Total Sum on Main Form of Datasheet Subform

[Drenda]

Can anyone help

I have a subform displayed as a datasheet with a column called "Budgets" (currency format) and would like to display the total in the main form but cannot seem to get it to work

My main form control source is written as

=[Category_Cost Centre_USD Table subform].[Form]![Budget]

where the subform is called Category_Cost Centre_USD Table subform

and the control on the subform is called Budget

Thanks

 

[Darrylles]

Hi Drenda,

Are you aware that your subform sits in a subform 'container'?

Rename the container to:
[CCC_USD_Container]

then refer to it instead:

[CCC_USD_Container].[Form]![Budget]

This will then refer to the budget field on the form contained within the container.

ATB

Darrylle




Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[Drenda]

Many thanks

works a treat!!!