Hi,
I Have my VB hooked up to Access and am trying to use multiple criteria searching one table. There is probably a simple answer I just can't find it. The code so far is:

Dim CurrentSalary As String
Dim EducationLevel As String
Dim JobSector As String

CurrentSalary = SearchCVresults.Combo9.Text
EducationLevel = SearchCVresults.Combo10.Text
JobSector = SearchCVresults.Combo11.Text

Data1.RecordSource = "SELECT * FROM CV WHERE Salary = '" & CurrentSalary & "' & EducationLevel = '" & EducationLevel & "' & JobSector = '" & JobSector & "' "

I've tried to use the FindFirst/Next/Last method aswell but that doesn't seem to be working either. PLEEASE HELP ME!