I am trying to connect MS Chart using ADODC with an Access query. It is displaying the null values and I need to display all the values in the query onto the chart. The code that I have is:

Dim SQL As String
Dim PathName As String
PathName = "c:\database name"
SQL = "Select DataValue from AccessQuery"
Form1.ADODC.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
"Persist Security Info=False;Data Source ='" & PathName & " ' "
Form1.ADODC.RecordSource = SQL
Set Form1.MSChart1.DataSource = Form1.ADODC

Please help!!!!



[This message has been edited by smiletaz (edited 08-11-1999).]