Ennistymon
asked on
Pivot Table Form with Button to Drill Down to the Detail
I have been asked to develop a form that will be a summary of the number of moves truck drivers make during their shift. The underlying table will include the driver's id, each unit the driver moved, whether loaded or empty, and so on. Making a pivot table for this is easy, but the difficult part is that they want a button at the end of each row of the pivot table that will enable the user to drill down to the record level to see the detail of these moves. My problem is that I can't add a button to the pivot form that when pushed will pull up the transactions for that driver. Any ideas of how I can do this?
Here is a very basic sample.
Perhaps you can study it carefully and adapt it to work in your database.
;-)
JeffCoachman
Access-EEQ26484038MovesAndMoveDe.mdb
Perhaps you can study it carefully and adapt it to work in your database.
;-)
JeffCoachman
Access-EEQ26484038MovesAndMoveDe.mdb
ASKER
Using your recommendation and modifying it a bit, I created a form from the pivot table query and also created a parameter query of the records details and made a form from that. Then I made the Pivot Form the main form and the Parameter form the sub form. The form shows a "+" sign to the left of the first column. When I click on it, the "+" runs the parameter query. The "+" changes to a "-" and drops down the detail results from the parameter query. Interestingly enough, when I go to print the detail, I only get the pivot summary results. Any idea how I can print the detail as well?
ASKER
For an unknown reason I can't open your file even after copying it to my machine.
I just downloaded it to myself and it worked fine.
Try downloading it again.
Also make sure that you have permissions to Add/copy, ...etc files to your destination Folder/Drive, ...etc.
Also try downloading it from another machine, or from home.
Jeff
Try downloading it again.
Also make sure that you have permissions to Add/copy, ...etc files to your destination Folder/Drive, ...etc.
Also try downloading it from another machine, or from home.
Jeff
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Jeff,
Thanks again for your help. Your example prompted me to think in a different way. I came up with a solution that works! Thanks again.
Thanks again for your help. Your example prompted me to think in a different way. I came up with a solution that works! Thanks again.
;-)
Also remember that the whole purpose of a Pivot table is to "summarize" the data. (Not displaying any real "detail" levels).
There may be some way to automate this though...
If you need to drill down from the "Move" to the "Move" details then:
1. The "Move" info and the "MoveDetails" info need to be in separate, related tables.
2. Then you can create a simple Main/subform.
This will allow you to select a "Move" in the main form and see the corresponding "MoveDetails" in the subform.
;-)
JeffCoachman