Form in Pivot Chart view in MDE

[Rick in NS]

I have a form based on an underlying query which is designed to open in pivot
table view thus allowing users to filter the data on the underlying tables.
The database is split frontend backend and I distribute the front-end as an
mde file to prevent access to the code or design of the forms or queries.
However; each time the user opens the form they have to re-select items from
the drop down lists in the pivot table since it opens with the defaults
chosen prior to the creation of the mde. As I understand it the changes are
not saved since the filter changes have to be saved with the design of the
pivot table which is impossible with an mde file. I could put a password on
the vba editor window and restrict design changes to forms or queries by
implementing full blown security but this would be both tedious and time
consuming considering the size of the application.

Any suggestions on how one might expose the form and underlying query for
this pivot table view so the latest changes to the filters can be saved for
the next time the form is opened in pivot table view?