Update chart based on query

[CaliburBlade138]

Afternoon,

I am trying to update a chart on a form using combo boxes, as I am not to familiar with charts this is what I have, I do not get any errors it just does not populate. Any help please?

Option Explicit


Private Sub comboNAME_Change()


Dim objChart As Chart
Set objChart = Me.Chart4


With objChart
    .ChartTitle = "myTimeKeeper"
    .RowSource = "SELECT * FROM tablemyTimeKeeper WHERE myDate=" & txtDATE.Value & " AND myName=" & comboNAME.Value & ""
    .ChartAxis = "myName"
    .ChartValues = "myDate"
End With


Me.Chart4.Requery


End Sub

[Gicu]

Please try:

.RowSource = "SELECT * FROM tablemyTimeKeeper WHERE myDate=#" & txtDATE.Value & "# AND myName='" & comboNAME.Value & "'"

[CaliburBlade138]

Thanks, got something working, still figuring out my X and Y axis and data though lol