Compile Error: Invalid Use Of Property When Assigning a Filter ToPivot Chart

  • Thread starter nouveauricheinvestments
  • Start date
N

nouveauricheinvestments

Hi,

I'm getting an error when trying to assign a filter to a pivot chart.
It tells me 'Invalid Use Of Property'. Any ideas why? I have been
working on this for a few days now.


Form_AggregatedDataChart1.Filter = "Employee = 'ken trionfo'"
Form_AggregatedDataChart1.FilterOn
 
D

Douglas J. Steele

Try:

Forms!AggregatedDataChart1.Filter = "Employee = 'ken trionfo'"
Forms!AggregatedDataChart1.FilterOn
 
N

nouveauricheinvestments

Try:

Forms!AggregatedDataChart1.Filter = "Employee = 'ken trionfo'"
Forms!AggregatedDataChart1.FilterOn
Click to expand...

It is giving me the same error message.
 
Top