Pivot table Subform

  • Thread starter Thread starter icq_giggles
  • Start date Start date
I

icq_giggles

The detail data does not stay. When I close and reopen the form, the columns
and rows and drop areas are there, but the data from the detail area has to
be re-applied. What am I doing wrong? I know how to manually put it back,
but my users don't.
 
I'm having the same problem with record source dynamic query. See my post
Dynamic Pivot Table.

It *is* possible to retain data in a pivot table / chart by drawing the data
from a temporary table. Seems these were designed for static, not dynamic,
data sources.
 
Back
Top