Easy SQL Question
Posted on 2001-06-22
Ok - I can't remember or find what I am doing wrong in this code, Here is the code:
Dim strSQL As String
Dim SrchWord As String
SrchWord = Combo1.Text
If txtCustSearch.Text = txtLastSKU Then Exit Sub
txtLastSKU = txtCustSearch.Text
strSQL = "SELECT FirstName, LastName,CustID,Address,City,State,Zip,Phone1,StateID from Customers " & _
"Where'" & SrchWord & "Like'" &_ txtCustSearch.Text & "%'"
The problem is in how I am bracketing SrchWord, I can't seem to get it to work, even though I know it's probably easy - I just can't seem to get it.
The combo box is filled with valid field names for search criteria (LastName, FirstName etc:)
Your help is appreciated.