Recent content by smcclure

Great JHB, thank you so very much!

Beware: it's a mess. To recreate the issue: enable macros, open the MainDataControl form and click "view historical". You'll get the enter parameter value dialog. Click okay through to the pivot chart and you'll see it's empty. The form that opened was UtilityChartWindow (it has the...

Am I so lucky as to have found an issue that no one has a solution for?

Update: I've traced back how far the filtering doesn't work in an effort to localize the error. If I apply the original string (stated above) to the pivotchart design-view Filter property, the proper chart displays in the pivotchart view. But if I try to open the exact same pivotchart as...

With regards to Access I'm amateur, but not novice. I have a pivotchart subform who's Filter Property I've set to: [EEIC_ID] In ([Forms]![MainDataControl].[EEICBuffer],0) And IIf([Forms]![MainDataControl].[TypeIDBuffer]="",[AG_TYPE_ID] Like "*",[AG_TYPE_ID] In...