I have a form that I use to search through my contacts. It's only bringing back results based off of the first letter in the contact. Example would be if I type the letter "A" it only brings up the names that start A. Not names that have the letter A in it such as "Brad". Below is the code I am using. Any thoughts?
Private Sub btnSearch_Click()
If Me.txtFirstName = vbNullString Then Me.txtFirstName = "*"
If Me.txtLastName = vbNullString Then Me.txtLastName = "*"
If Me.cboCounty = vbNullString Then Me.cboCounty = "*"
Dim SQL As String
SQL = "SELECT * from Contacts where FirstName Like '" & Me.txtFirstName & " *' AND LastName Like '" & Me.txtLastName & "*' AND County Like '*" & Me.cboCounty & "'" & " ORDER By LastName"
' Debug.Print SQL
Me.CountactSubform.Form.RecordSource = SQL
Me.ContactSubform.Form.Requery
End Sub