Search results

Hi All For any one else that needs some thing like this, then I have just found the solution: Private Sub Report_Load() Set frms = Me.OtherCases_created_by_Indv_by_Month_chart.Form.ChartSpace.Charts(0) Dim i As Long With frms For i = 0 To Me.[OtherCases created by Indv by...

Hi All, I have a bar pivot chart made in a form this load fine, I have the below VBA code in place to control the bar color depending on what the bar show. Set frms = Forms![OtherCases created by Indv by Month chart].Form.ChartSpace.Charts(0) Dim i As Long With frms For i = 0...