Form / Pivot Chart Design Question

[Guest]

Dear all,

I've produced a series of forms, which open as pivot tables when I select
them from the database window view.

All are a series of summary tables, which total up the no. of attendances to
a particular hospital clinic by type of patient.

On my front screen, i've put a series of command buttons, all of which i've
set up to "open" the individual pivot chart forms.

They open the forms ok, but do not open them in pivot chart view - they show
the underlying records beneath them.

Is there a way I can set the buttons up to ensure they only open the forms
in the pivot chart view?

Thanks,

David

 

[Guest]

Hi,
The way I do this is to set the on-click property to run a macro. The macro
opens the form and you can set the view to pivot chart. Hope this helps.