filter doesn't seem to be working

Hi.

I have a pivot table that works on all the records in a table. I want to apply a filter through VBA code as follows:

DoCmd.OpenForm "fpvtAxisI", acFormPivotTable, , "[Part]='1a'"

The filter doesn't seem to be working because all the records got displayed just as if there's no filter.

I tested by putting the filter "[Part]='1a'" directly in the Filter property of the form. It didn't work neither.

I have the same problem applying a filter to a report.

What am I doing wrong?

thanks

kevin

[585 byte] By [lessthanl0l] at [2007-12-24]