Good aftrenoon
I would like to know how to use a recordset to fill a chart i have in a form.
Chart has the rowsource property which can accept SQL string, table, values but it does not seem to accept recordset.
Other controls such as listbox, combobox or form accept recordsets through the rowsource or recordset properties. What about the graphs?

Any solutions?

Thanks in advance

Sylvain

Access 2007
Microsoft Graph 12 library

?Accept which recordset? How are you deriving that recordset? How are you attempting to set the chart to use it?

More info, please...

Thanks for your reply.

As an example, i am using ADO recordsets which contain the result of pass-through queries as the rowsource of some of my comboxes and as datasource of some continuous sub-forms to populate.

me.CbBox.RowSource = rs.GetString(adClipString, , ";", ";") or Set Me.subForm.Form.Recordset = rs with rs as an ADODB.recordset

I just wanted to know if the same was possible with the chart.

Thanks.

Sylvain