How to Use a Subreport in MS Access

In this episode, we're going to look at how to put a small report inside another report in MS Access. This is called creating a "subreport", and we'll be using the subreport object on a main form to display the subreport data, and to link the data to the particular row we are viewing. This will allow us to put a small descriptive report on each row of our current report, filtered to show just what we want to see. Let's go make a subreport!
Related Videos:
An Introduction to Reports in Microsoft Access
• An Introduction to Rep...
How to Do Grouping and Sorting of Report Data in Microsoft Access
• How to Do Grouping and...
How to Use a Subreport in MS Access
You are watching this video now!
How to Return a Message Instead of an Empty Report in Microsoft Access
• How to Return a Messag...
How to Use Nz in Microsoft Access to Handle Null and Empty Values
• How to Use Nz in Micro...
How to Format Dates in MS Access Queries, Forms, and VBA Code
• How to Format Dates in...
2 Ways to Use a Calculated Column on Your MS Access Report
• 2 Ways to Use a Calcul...
Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :
/ mackenziedataengineering
Demo of my BZ RDP Cloaker:
www.patreon.com/posts/how-to-...
Want to work with me 1:1? Contact me today and book your free 20 min consultation!
Contact form you can find at www.mackenziemackenzie.com/
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksynergy.com/fs-bin/...
Got a TH-cam Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy.com/seanmackenz...
For developers looking for a new role, check out:
www.toptal.com/qKaO2b/worlds-...
Needing to hire technical resources for your project? Get the best:
www.toptal.com/qKaO2b/worlds-...
• How to Use a Subreport...

[@seanmackenziedataengineering]

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

[@josemarandre1971]

Many thanks

[@seanmackenziedataengineering]

No worries!

[@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

[@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. th-cam.com/video/c45ny4vQGFs/w-d-xo.html

[@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.