Building a chart from VBA arrays

[mangesh_yadav]

Hi,

I want to build a chart on an Access Form through VBA code from array
defined within the code. Is it possible in access. I know that it i
possible in excel.

For instance, in access one has to do something like "myGraph.RowSourc
= StrQuery" where strQuery is an sql query built on the fly inside th
vba code. Instead, I want to run the query and build an array and the
use this array to build the chart. something like SeriesX = Array1()
seriesY1 = Array2(), seriesY2 = Array3(), and so on