R
Rodders
Hi,
Could some one help with this a query regarding pivot tables please. I
have a form into which I've placed a pivot table. If you open the form,
and then start to 'drill down' i.e. show details on elements within the
pivot table then close the form, when you next reopen the form the
pivot table is in the state you left it i.e. with the details showing.
Is there something I could put into the on close, or open event of the
form to ensure that when its open the detail is hidden?
Regards
Kev Thornton.
Could some one help with this a query regarding pivot tables please. I
have a form into which I've placed a pivot table. If you open the form,
and then start to 'drill down' i.e. show details on elements within the
pivot table then close the form, when you next reopen the form the
pivot table is in the state you left it i.e. with the details showing.
Is there something I could put into the on close, or open event of the
form to ensure that when its open the detail is hidden?
Regards
Kev Thornton.