Chart requery

[wichtel]

Hello

I want to display the maximum y scale of a chart in an text box. When I change the source of the chart and requery, I don't get the current maximum y scale but the previous one. Have you any idea how I can get the current maximum scale? the code is like this:

strSQL = "SELECT Date, R68, R69 FROM " & Me.Type

With Me!Subform_Chart!Chart
.RowSource = strSQL
.Requery
End With

With Forms!F_Menu!Subform_Chart!Chart
.axes(2, 1).MaximumScaleIsAuto = True
Chart_LT_Default = .axes(2, 1).MaximumScale
End With

Forms!F_Menu!Subform_Chart.Form.Requery

Thanks for your help!
Tim

 

[Edski]

Same problem

I have the exact same problem. Except I use

Dim myChart As Object
Set myChart = Me!myChart.Object.Application.Chart

to reference the chart object in the form. In any case the chart just doesn't seem to have the most recent values - just like you. It's driving me bonkers!