?
Solved

how to edit Field List in subform's PivotChart

Posted on 2014-02-13
4
Medium Priority
?
436 Views
Last Modified: 2014-02-25
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
0
Comment
Question by:developingprogrammer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39861479
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
 

Author Comment

by:developingprogrammer
ID: 39884566
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
 
LVL 14

Accepted Solution

by:
Bill Ross earned 2000 total points
ID: 39885256
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
 

Author Comment

by:developingprogrammer
ID: 39888023
hi Bill, yup i think that's the closest to what we can achieve. thanks for all your help an patience! = )
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question