All - looking for some insight here, any help would be appreciated.
I have two pivot table sub-sub-forms that stopped displaying data in the pivot table, but the other pivot table areas (filter, row, column) remain populated correctly.
Where the data should be displayed I get the following message:
"The query could not be processed: o Query canceled. Press F9 to restart the query and display data."
Background:
Both of the pivot tables are tied to two queries. The two queries, have filters related to 2 combo boxes and 1 text box, forcing the pivot table queries to always be synchronized, resulting in the pivot tables being synchronize.
Notes in my debug process so far:
Any one encountered this type of thing before? Thanks in advance for your time/help!
Mike
I have two pivot table sub-sub-forms that stopped displaying data in the pivot table, but the other pivot table areas (filter, row, column) remain populated correctly.
Where the data should be displayed I get the following message:
"The query could not be processed: o Query canceled. Press F9 to restart the query and display data."
Background:
Both of the pivot tables are tied to two queries. The two queries, have filters related to 2 combo boxes and 1 text box, forcing the pivot table queries to always be synchronized, resulting in the pivot tables being synchronize.
Notes in my debug process so far:
- Pressing F9 doesn't seem to do anything.
- In vba, I'm using as part of the subform's control, Me.pvtOrder.requery, which used to work and still half works as it the pivot table filters, rows, and columns drop downs are updated and display the correct selection
- When the tab, containing the pivot table is right clicked and subform-->form is selected the pivot table data displays...which is very manual.
- The pivot table forms, when opened directly display the data correctly
- The pivot table querries, when opened display the data correctly
Any one encountered this type of thing before? Thanks in advance for your time/help!
Mike
