Pivot table Subform

[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.

 

[icq_giggles]

Can no one answer this? I've seen several posts like this but no answers.

 

[Frustrated]

I'm having the exact same problem and can't seem to find any answers on this.

 

[Geo., Jr.]

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.