Pivot Graphs in Access 2003

[uzymedphys]

Hi

I have created three pivot graphs (e.g. GUGraphFilter1) in Access 2003 and is linked to a source table.

I created a new form - and added a 'command' button.

Next, in the commandbutton click event - I simply stated the following:

cmd.openform("GUGraphFilter1")

I click the command button and it shows the Pivot Graph in a datasheet view - why? I am expecting the Pivot Graph to show up.

I have also set NO to all views except 'Pivot View' in the 'GUGraphFilter1' properties.

Any ideas?

Thanks

Usman

 

[motleyjew]

You need to specify in the code what how you want to open it. Try this:

DoCmd.OpenForm "GUGraphFilter1", acFormPivotChart

Gregg

 

[uzymedphys]

Thanks for that Greg - worked wonders.

I tried to combine all three plots (graphs i.e. filter 1, 3 and 4) into one pivot graph.

The problem is the values then change (with respect to each other) and its filtered as max, min or average (of all three columns).

How can I plot three independant curves (with the same X-axis i.e. dates) and have different (slightly) different outputs (y-axis) i.e. use all three filters in one pivot graph?

I feel I am missing something here?

Any more ideas? (see attached zip for a visual of the problem)

Many thanks

Usman