Changing primary view

[ScottBeatty]

Hi everyone. I was wondering if it is possible to change the primary view for queries from the table view to say, the Pivot Chart view?

Thanks

 

[pr2-eugin]

If you are opening the Query using DoCmd method you can control how it is opened..

DoCmd.OpenQuery "yourQueryName", acViewPivotChart

 

[ScottBeatty]

sorry what is the "DoCmd" method? I'd like to use a button in a form to automatically go to the Pivot Table if that helps at all

 

[pr2-eugin]

Yes, you can use the button to Open a Query using the DoCmd.OpenQuery method..

 

[ScottBeatty]

Okay perfect thank you

 

[ScottBeatty]

Oops the first button worked but now that I added, about 25 more, none of them work and they are all referencing different queries.

I'm getting the error message "The expression On Click you entered as the event property setting produce the following error: Ambiguous name detected [on a specific button, even though I copy and pasted and just changed the info]."

Any suggestions?

 

[ScottBeatty]

Ahhh nevermind. Careless error. Thanks again!

 

[pr2-eugin]

Ahhh nevermind. Careless error. Thanks again!

Ha ha, Glad you have it sorted.. Good Luck !