Opening a pivot table

[crowegreg]

On a form, I've created a command button to open an existing pivot table. Here is the command line:



DoCmd.OpenForm "frm_Pivot_Financial_Data", acFormPivotTable, , , acFormReadOnly

This opens the pivot table. Unfortunately, it allows the user to make changes to the pivot table. What is the easist way to make the pivot table read only?

Thanks in advance

[June7]

Can pivot table be the RecordSource for a report?

I've never used pivot table/chart/form

[crowegreg]

You've got me. I'll try it out, and let you know.

[crowegreg]

The form pivot table's recordsource is a query. If I create a report, it looks like it would be easier to just use the query as the recordsource.