Hello,
I want to create a pivot table form with Access 2003.
The user selects fields and then when he clicks to a button I create the pivot table form (and I add fields to the fieldset), the user closes the form when he has finished the settings and I save the settings on the form.
But if the user modify the lists of fields and wants to reopen the pivot table form, the form is blank, and all the old settings are lost.
If I add a field to the fieldset :
acsFrmPivot.PivotTable.ActiveView.AddFieldSet("field")
or I reload the record source:
acsFrmPivot.RecordSource ="tb_name"
the form is blank.
can someone help me?
Thanks
I want to create a pivot table form with Access 2003.
The user selects fields and then when he clicks to a button I create the pivot table form (and I add fields to the fieldset), the user closes the form when he has finished the settings and I save the settings on the form.
But if the user modify the lists of fields and wants to reopen the pivot table form, the form is blank, and all the old settings are lost.
If I add a field to the fieldset :
acsFrmPivot.PivotTable.ActiveView.AddFieldSet("field")
or I reload the record source:
acsFrmPivot.RecordSource ="tb_name"
the form is blank.
can someone help me?
Thanks
