Main form with subforms

[Nadiawilkes]

Hello Everyone, hoping for some help if I can.
i have a main form that runs from a table that only has a few fields. However on this main form I have 5 subforms. They are linked to the main form by a date field. The subforms are one for each day of the working week. I am actually using it for a daily cash flow where I work. It all works very well with the exception of one thing.

I have in each of these subforms a datasheet that totals at the bottom. This is to total all the debuts on the form. All good. The problem I have is that I then want to add that total on the main form under each of the subforms so that I can use The amount in a calculation on the main form. i am not sure how to achieve this so am hoping for help. At the moment I have to type into a field on the main form the figure from each subforms myself so that it will be part of the main form calculations. on the main form I have total income fields, total debits field to give the carry over balance. Manually adding the ones from the subform obviously works but there must be a better way? Any and all help appreciated. Thanks

 

[bob fitz]

Can you post a copy of the db with a couple of dummy records

 

[jdraw]

Welcome to the forum.
You might get more focused responses if you provide a copy of your database (ZIP format) with few sample records showing the issue.

 

[Nadiawilkes]

No problem. I will do it when I am at work tomorrow. Thanks

 

[bob fitz]

You could set the Record Source property of a text box on the main form, to reference the text box on the subform footer.
Something like:

=Nz([NameOfSbform].[Form]![NameOfTextbox],0)

 

[Nadiawilkes]

Thanks. I’ll try that.