Sub Report Populating Main Report.

[SeniorCitizen]

A form that has four calculated text boxes which I believe cannot be summed for the footer totals. So I have created a sub report bound to a query with all the totals. I will make the sub Report not visible and would like to populate the totals in the footer of the main report on load or some other function as i do not want the operator to click a button. Sounds easy but I have not done it before.

I'll appreciate any suggestions or thoughts

[Bob Fitz]

A form that has four calculated text boxes which I believe cannot be summed for the footer totals

Why can't they be summed?

[SeniorCitizen]

When I attempt to sum the calculated text box The sum option is not available

[Bob Fitz]

When I attempt to sum the calculated text box The sum option is not available

I think it should be possible.
Can you post a copy of the db for us to play with.

[mike60smart]

Can you post a screen shot of the Form in Design View?

[SeniorCitizen]

Sorry this is a report not form.

[Bob Fitz]

Sorry this is a report not form.

You should still be able to sum textboxes that are in the detail section and show the total in the footer section.

[Bob Fitz]

Can you post a copy of the db for us to play with.

[SeniorCitizen]

The data base is large. What specifically would wantnto see

[Bob Fitz]

The data base is large. What specifically would wantnto see

The report and any tables/queries that the report needs.
For instruction on how to post, click the button at the very top of this post "How to Attach Files"

[SeniorCitizen]

I have found the solution which is as follows: =[Sub1].[Report].[txtTotal] as control source in my total text box.
Does exactly what I was looking for.

Thanks for your time and suggestions

[Bob Fitz]

I have found the solution which is as follows: =[Sub1].[Report].[txtTotal] as control source in my total text box.
Does exactly what I was looking for.

Thanks for your time and suggestions

Glad you have a solution. Good luck with your project.