populate chart category from a combobox
Iím using VB 6 as a front end to Access 03 database to populate the MSChart control.
I have a combobox for defect categories. I would like to populate the chart with a single category selected from the combobox.
Not sure what to put in place of the * as shown in the statement below. I would like to display the date (Weeks) and the category with the number of defects.
thanks for any help
Private Sub CategoryView()
' Display the category of chart data
Set cmd.ActiveConnection = cn
cmd.CommandText = "SELECT * FROM tbliface WHERE [Weeks] = '" & cboCategory.Text & "'" _
& " ORDER BY [Weeks]"