Displaying a subform total

[DebbieV]

Hi,

I would like to show a grand total of the other three subforms, in the forth subform,let me explain. I created a main form with four sub forms using the tab control, so it looks like another form and not several datasheets. One of the sub forms is going to have financial info. So I would like the totals from the other three subforms to give me a grand total on the fourth subform rather than on the main form. Is this possible? When I entered the name of the subform into the control source of the forth subform I get a #NAME? displayed. I am entering =[Name of subform]![Name of subformControl].

Look forward to your response.

Debbie

 

[doss]

Hello.

Maybe you need something like this?

=[Name of MainForm]![Name of subform1]![Name of control on subform1] + [Name of MainForm]![Name of subform2]![Name of control on subform2] + [Name of MainForm]![Name of subform3]![Name of control on subform3]

 

[DebbieV]

Thanks doss,

I will give it a try, make sense.

Debbie