Access 2016 - Drill Down Reporting Question

Greetings!
Is it an option to create a button within a report?

My goal is to start with a top level report for the entire company.
A click on a division would bring up the same report filtered to the data for that division.

Thanks for the insights!
Dennis
DGWhittakerAsked:
Who is Participating?
 
PatHartmanConnect With a Mentor Commented:
This is another one of those "features" that sounds good on paper but won't make you happy in real life.

Events for controls are only active in Report View.  But Report View has some drawbacks.  For example, it doesn't actually paginate.  There are no page breaks.  It also doesn't run code in the Format or other events.

I would create different reports and let the user choose which level he wants to see from a selection on a form.
0
 
COACHMAN99Connect With a Mentor Commented:
It is doable but will require a lot more work than a dropdownbox as the filter. If the user doesn't select from the dropdown then show all else show sub-set based on selection
0
 
crystal (strive4peace) - Microsoft MVP, AccessConnect With a Mentor Remote Training and ProgrammingCommented:
better would be to build a form to use for a report menu with a choice of all the divisions.
Then, in the OpenReport statement, use the Where parameter to limit the report for those choices.

I am actually making a video to demonstrate this right now ... will be posted this week
0
 
COACHMAN99Commented:
except the requirement is to '..same report filtered to the data for that division.' (singular)
0
 
DGWhittakerAuthor Commented:
Thanks All!
Dennis
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.