Runtime error 3075

  • Thread starter Thread starter Chris1
  • Start date Start date
C

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
 
Back
Top