force pivot table view from control button

[migrant_lad@yahoo.com]

form to view in pivot table view is based on query. form default view
is pivot table and will function when the form is opened directly. The
problem is that when the form is opened from a control button, it
defaults to the form view

[Donald Calloway]

Re: force pivot table view from control button

migrant_lad@yah oo.com wrote:

form to view in pivot table view is based on query. form default view
is pivot table and will function when the form is opened directly. The
problem is that when the form is opened from a control button, it
defaults to the form view

Why not have the control button run a macro that opens the form in pivot
table view?

[Bob Quintal]

Re: force pivot table view from control button

Donald Calloway <drcalloway@ver izon.netwrote in
news:_hvFj.710$ o35.252@trnddc0 7:

migrant_lad@yah oo.com wrote:

>form to view in pivot table view is based on query. form default
>view is pivot table and will function when the form is opened
>directly. The problem is that when the form is opened from a
>control button, it defaults to the form view

>
Why not have the control button run a macro that opens the form in
pivot table view?
>

Why create a macro? All that's required is to change the
docmd.openform call to change the second argument to acFormPivotTabl e

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com