How to Use a Subreport in MS Access

[@seanmackenziedataengineering]

Download the file used in this video: mackenziemackenzie.com/downloads

[@jaironaranjo3654]

Another great Presentation

[@RolfF.Widmer]

Thanks Sean, your video help me a lot! Btw. I like your background music. I also heard a wolf howl (I guess) and a train passing 🙂

[@seanmackenziedataengineering]

Thanks - that office I had a few years ago was right beside some train tracks. I usually had to pause recording while trains went by 😂

[@RolfF.Widmer]

Thanks

[@seanmackenziedataengineering]

Many thanks!

[@v0vo4ka78]

Please write a link to the file in which you are working in the video, and thank you for you video)

[@seanmackenziedataengineering]

You can get a download at mackenziemackenzie.com/downloads Look for the entry on 2021-11-02. It also has some design for the filter by month which was done on this dataset. kzbin.info/www/bejne/mWWYn6xqq7Z6fNU

[@Jaylea1010]

Thanks for the great help! Is there a way to change formatting for each "main" report? I.E. I have multiple companies that use the same subreport. I want to use the formatting for each company (ex. colors and font) but the data is coming from the same query. I have different main reports for each company pulling the same subreport.

[@seanmackenziedataengineering]

You can make changes to colors and things when you use the On Format of different sections of the report object. Open Report in Design > right-click Detail bar > On Format > Code > type something like Me!txtSomething.ForeColor = vbRed When you open the report you'll see that textbox has red lettering. Try it! You can then do something like If Me!txtCompany = "Acme Co" Then Me!txtSomething.ForeColor = vbGreen

[@josemarandre1971]

Many thanks

[@seanmackenziedataengineering]

No worries!

[@NotMuchHere]

I tried to create something like this ...on a form one table with 12 rows, a sub table with 50 per row, and a sub table to that with 1-1000 rows per sub row. When the form came up, the master section had 10000 rows and the next previous never changed the master row it move the sub sub report ... this is not what was wanted ... is yours better?

[@seanmackenziedataengineering]

It sounds like you need to set the Parent-Child settings on each subreport object so that it filters each detail section. You need to select the subreport container on the parent form in order to see this. Let me know if you cannot find the setting.