how to edit Field List in subform's PivotChart

hey guys, i have a form with a subform. the subform is in pivotchart view.

how do i edit the field list? is it possible? the field list is greyed out.

thanks guys!

PivotChart.mdb
developingprogrammerAsked:
Who is Participating?
 
Bill RossConnect With a Mentor Commented:
Hi,

You can change the recordsource for the form or the controlsource for the fields programmatically.  In the OnOpen event for example you can change:

forms!Query_qry subform.recordsource = "Query1"

me!Field1.controlsource = me!Field2

Regards,

Bill
0
 
Bill RossCommented:
Hi,

In a pivotchart the field names are the data so unless you cnange the data the field names are set.  This is by design.

Regards,

Bill
0
 
developingprogrammerAuthor Commented:
hi Bill, thanks for your help!

i was referring to the addition / removal of fields to the "Drop Series Fields Here" / "Drop Category Fields Here" in the subform.

i don't think that's possible? i've attached the test database in the above question, not sure if that helps! = )
0
 
developingprogrammerAuthor Commented:
hi Bill, yup i think that's the closest to what we can achieve. thanks for all your help an patience! = )
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.