Help with Chart in Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I inserted a chart (XY Scatter) into my form and it words fine. However,
when I close and re-open the form and or file the chart does not reactivate.
I must double click it open and click the data button to read "Rows" and back
again to "Column" and it works fine again. Until I close it down.

The chart property box I have row source: SELECT qryMitiChart.X, qryMitChart.Y
FROM qryMitChart
ORDER BY qryMitChart.X;

Is there a Property setting or Event statement I should be using? Any advise
would be helpful.
Thanks Steve (e-mail address removed)
 
I inserted a chart (XY Scatter) into my form and it words fine. However,
when I close and re-open the form and or file the chart does not reactivate.
I must double click it open and click the data button to read "Rows" and back
again to "Column" and it works fine again. Until I close it down.

The chart property box I have row source: SELECT qryMitiChart.X, qryMitChart.Y
FROM qryMitChart
ORDER BY qryMitChart.X;

Is there a Property setting or Event statement I should be using? Any advise
would be helpful.
Thanks Steve (e-mail address removed)
Click to expand...

Did you try requerying the control in the form's Load event:
Me!OLEUnboundName.Requery (or Refresh, I can never remember :-) )
 
Back
Top