Aug 17 2010, 11:07 PM
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?
Thanks in advance
Microsoft Graph 12 library
Aug 18 2010, 08:51 AM
?Accept which recordset? How are you deriving that recordset? How are you attempting to set the chart to use it?
More info, please...
Aug 18 2010, 04:16 PM
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here