Hi everyone,
I am creating a form, where I have inserted three pivot charts and a pivot table. The three pivot charts' data is controlled by three combo list. My pivot table has no parent/child link at all, and my form has the record source empty.
When I make a selection to the combo list, the filters of my pivot table stops working and no data can show. It says that there is a problem running the query due to structural changes. But I am not sure what I did wrong.
I am speculating that I may need to add a macro to the pivot table or the combo list to not get affected by each other.
Can anyone please let me know what I may have been doing wrong?
I am using access 2010.
Any response would be greatly appreciated.
Thank you,
Quenica
I am creating a form, where I have inserted three pivot charts and a pivot table. The three pivot charts' data is controlled by three combo list. My pivot table has no parent/child link at all, and my form has the record source empty.
When I make a selection to the combo list, the filters of my pivot table stops working and no data can show. It says that there is a problem running the query due to structural changes. But I am not sure what I did wrong.
I am speculating that I may need to add a macro to the pivot table or the combo list to not get affected by each other.
Can anyone please let me know what I may have been doing wrong?
I am using access 2010.
Any response would be greatly appreciated.
Thank you,
Quenica
Last edited:
