Runtime error 3075

[Chris1]

Hi,

I am struggling with this line of code and cannot solve it!

CurrentDb.QueryDefs("qryExample").SQL = strSQL

When clicking on the cmdFind button on my form,
I get this message: Runt time error 3075. Syntax error
(missing operator) in query expression...

The full sub is as follows:
Private Sub cmdFind_Click()

Dim strSQL As String

If Not EntriesValid Then Exit Sub

If Not BuildSQLString(strSQL) Then
MsgBox "There was a problem building the SQL string"
Exit Sub
End If

MsgBox strSQL

CurrentDb.QueryDefs("qryExample").SQL = strSQL

End Sub

Please can soeone have a look at it and help.
Thanks,
Chris1

 

[Terry]

What value do you have in strSQL?
Terry