Requery a pivot chart

[Noreen]

Hi,

My database records managers ratings of sales peoples competencies. I have designed a form for managers to enter this data which works ok.

My manager now wants to insert a chart in a seperate window linked by a button to show progress of the sales reps/team depending on the manager(Team Leader pick)

However I am running into problems when I try to requery in a pivot chart, I have used this method for a list box and it works:

Private Sub TeamLeader_AfterUpdate()
Me.Tenure = Null
Me.Tenure.Requery
Me.Tenure = Me.Tenure.ItemData(0)
Forms("Training Done").Controls("Training").Requery
Forms("frm_spiderweb").Controls("TeamLeader").Requery
End Sub

I recieve the following error when I try to change the Team Lead combo box:

"Run-time error '2478':
 
Microsoft Office Access doesn't allow you to use this method in the current view"

Does anyone have any idea where I have gone wrong?

I inserted:

[forms]![Prog_Report]![TeamLead]

in the query that was used to create the chart.

If anyone could please help, it would be greatly appreciated?!