Hi I am getting a Compile Error with the following code with the highlight strsearch = The code is below:
Option Compare Database
Option Explicit
Any help to get rid of the error would be gratefully appreciated. Thank you very much
Option Compare Database
Option Explicit
Code:
Private Sub btnSearchCarlsbad_Click()
Dim strString As String
Dim strText As String
strText = Me.txtSearch.Value
strsearch = "Select* from Carlsbad where ((LineItemCode like ""*" & strText & "*"") or(FirstName like ""*" & strText & "*"")or(ServiceAddress like ""*" & strText & "*"") or(Location like ""*" & strText & "*"") or (LastName like ""*" & strText & "*""))"
Me.RecordSource = strsearch
End Sub
Any help to get rid of the error would be gratefully appreciated. Thank you very much