digitalshepard
Registered User.
- Local time
- Today, 04:00
- Joined
- Jul 20, 2011
- Messages
- 32
Background:
I have a form and 2 subforms - subform1 is a pivotchart and subform2 is a datasheet generated by a query. I would like to filter the results of the datasheet based on fieldbuttons selected in the pivotchart.
Discussion:
I have accomplished similar tasks using a syntax similar to Forms!Mainform!Subform1.Form!ControlName as a criteria in the query for form2. However, I haven't seen anything on how to refer to control names in PivotChart (or even if there are control names.)
Any thoughts? Is this possible?
I have a form and 2 subforms - subform1 is a pivotchart and subform2 is a datasheet generated by a query. I would like to filter the results of the datasheet based on fieldbuttons selected in the pivotchart.
Discussion:
I have accomplished similar tasks using a syntax similar to Forms!Mainform!Subform1.Form!ControlName as a criteria in the query for form2. However, I haven't seen anything on how to refer to control names in PivotChart (or even if there are control names.)
Any thoughts? Is this possible?