Open Report Syntax Error

[lexi0088]

I have the following code that keeps giving me syntax error (missing operator) in query expression "[CBNumber]= 79CB". I am running Access 2007.

Private Sub Command34_Click()
On Error GoTo Err_Command34_Click

Dim strDocName As String
Dim strWhere As String

strDocName = "Chargeback"
strWhere = "[CBNumber]= " & Me!CBNumber
DoCmd.OpenReport strDocName, acPreview, , strWhere, acWindowNormal

Exit_Command34_Click:
Exit Sub

Err_Command34_Click:
MsgBox Err.Description
Resume Exit_Command34_Click

End Sub

Please help!!

 

[PHV]

strWhere = "[CBNumber]=[!]'[/!]" & Me!CBNumber [!]& "'"[/!]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[lexi0088]

PHV, YOU ARE AWESOME!!! Thank you so much, I must have tried every combination but that yesterday.