G
Geo., Jr.
I made a form with recordsource = "select tbl1.fld1, tbl2.fld2,
sum(tbl1.fld3) from tbl1 inner join tbl2 on tbl1.fld1 = tbl2.fld4 where
tbl2.fld5 = "<some variable>
Then I made a pivot table using data in this form. I can open the form in
form view and change to pivot table view and the pivot table data is
preserved. But if I set the default view to pivot table, the form opens
blank.
Is there a way to change views programmatically.
I am also looking for a method to create the pivot table dynamically, but
believe the method described in Programming Pivot Tables for Access Forms
(http://msdn.microsoft.com/en-us/library/aa662945(office.11).aspx) is not
supported in Access 2007.
TIA.
sum(tbl1.fld3) from tbl1 inner join tbl2 on tbl1.fld1 = tbl2.fld4 where
tbl2.fld5 = "<some variable>
Then I made a pivot table using data in this form. I can open the form in
form view and change to pivot table view and the pivot table data is
preserved. But if I set the default view to pivot table, the form opens
blank.
Is there a way to change views programmatically.
I am also looking for a method to create the pivot table dynamically, but
believe the method described in Programming Pivot Tables for Access Forms
(http://msdn.microsoft.com/en-us/library/aa662945(office.11).aspx) is not
supported in Access 2007.
TIA.