I have a Pivot Table that pulls from a massive data set. For several reasons, including improved speed and ease of use, I would like to dynamically change the Record Source of the form via VBA at load to filter the raw data pulled in.

Experimentation has shown that when I change the Record Source of the form, it clears all design elements of the pivot table. In other words, it loads completely blank. No doubt this is one of those wonderful "working as designed" characteristics that I so love.

Does anyone have any experience with doing this, or an idea for a work around?