Adding " " to the value from a combo 1

[UongSaki]

How do I change this statement

If CheckDivison Then
strWHERE = strWHERE & "D.Divisions = " & (ComboDivision)
End If

so that my SQL result is

SELECT D.*
FROM TblFinalData AS D
WHERE D.Divisions = "All CMP";

and NOT this

SELECT D.*
FROM TblFinalData AS D
WHERE (((D.Divisions)=All [CMP]));


Thanks,

UongSaki

 

[dtqbterror]

If CheckDivison Then
strWHERE = strWHERE & "D.Divisions = " & Chr(34) & (ComboDivision) & Chr(34)
End If

http://www.chiefscoalition.com

 

[cLFlaVA]

If CheckDivison Then
    strWHERE = strWHERE & "D.Divisions = " & _
    Replace(Replace(ComboDivision, "[", ""), "]", "")
End If

*cLFlaVA
----------------------------
Ham and Eggs walks into a bar and asks, "Can I have a beer please?"
The bartender replies, "I'm sorry, we don't serve breakfast.