First I will explain my ultimate goal just in case someone has done something like this before.
I have a PivotChart that acts as a SPC Control Chart. This Control Charts displays the pH reading values of each record in the database. When pH readings are "Out of Control," certain text box fields are filled in to describe why the measurement was "Out of Control" on the main form.
I would like to set up my PivotChart so that when the user selects a point on the chart, the comments associated with that record will be displayed in either another form, or on the Pivot Chart itself (in the ScreenTips).
So far I have discoverd the Form_SelectionChange event, which will fire each time I select a different point on my PivotChart. The problem is the record does not change when you select different points. The form is always stuck on the most recent record no matter what point you choose.
Is there a way to determine the record of the point you are highlighting in a PivotChart? I think after I figure this out I can do the rest.
Thanks for any input in advance!
I have a PivotChart that acts as a SPC Control Chart. This Control Charts displays the pH reading values of each record in the database. When pH readings are "Out of Control," certain text box fields are filled in to describe why the measurement was "Out of Control" on the main form.
I would like to set up my PivotChart so that when the user selects a point on the chart, the comments associated with that record will be displayed in either another form, or on the Pivot Chart itself (in the ScreenTips).
So far I have discoverd the Form_SelectionChange event, which will fire each time I select a different point on my PivotChart. The problem is the record does not change when you select different points. The form is always stuck on the most recent record no matter what point you choose.
Is there a way to determine the record of the point you are highlighting in a PivotChart? I think after I figure this out I can do the rest.
Thanks for any input in advance!
