E
Etienne
I have a form in Access where the user customize his
PivotChart and Table to his needs. The graph and tables
are subforms and are modified by the options the user
select and change. Initialy the subforms are completly
blank and the user contruct all the Pivot by himself.
After the user finish with the design of the table, I want
to be able to view it in a report. But the thing is that
if I include a subform of the pivottable in the report,
it'll display an empty table since the subform is initialy
empty before the design. What is modified by the user is
an instance of the subform... But I can't get the subform
in the report to take his source object from the
pivottable-subform in the form where the user design it.
Anyone have an elegant solution?
PivotChart and Table to his needs. The graph and tables
are subforms and are modified by the options the user
select and change. Initialy the subforms are completly
blank and the user contruct all the Pivot by himself.
After the user finish with the design of the table, I want
to be able to view it in a report. But the thing is that
if I include a subform of the pivottable in the report,
it'll display an empty table since the subform is initialy
empty before the design. What is modified by the user is
an instance of the subform... But I can't get the subform
in the report to take his source object from the
pivottable-subform in the form where the user design it.
Anyone have an elegant solution?