Hi all,

In our project, we have a scenario as follows.

The output is a report with data fetched through a Pivot Table (Base data is in a cube). We enter the department numbers in the MS ACCESS Form. The data is stored in a table. This data is taken as lookup data to the report. In the report, We need select the Departments that are present in the lookup.

I tried a round about way for the same. It works well when i just run the macro from the excel. But when i try to run it from the MS ACCESS application.

It fails in the line to enable the multiplie page items...

".Cubefield.EnableMultiplePageItems"

It says Application-Defined or object-defined Error. If i click on the pivot item manually. enable multiple items. then it works...Is there any ADDINS or REFERENCES in my ACCESS application i have to add...Pls let me know...

Thanks,
Arun