select into database problem

[djgaidel]

I am doing this.

Query = "select  'Number' from database.students where Course ='" & ComboBox1.SelectedItem & "'"

and after that number from my database will be saved into my combobox. But the problem is i cannot retrieve the number based on the course i choose.