[RESOLVED] Syntax error (missing operator) in query expression 'Surname Arshad'.

[hasin_arshad]

 Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click

        Dim cmd As New OleDbCommand("SELECT * FROM tblContacts where Surname " & txtSurname.Text & "", con)

        dr = cmd.ExecuteReader

        If dr.HasRows Then
            dr.Read()

            txtfirstName.Text = dr("Surname")
        End If



    End Sub

[TysonLPrice]

"SELECT * FROM tblContacts where Surname = '" & txtSurname.Text & "'"

[hasin_arshad]

"SELECT * FROM tblContacts where Surname = '" & txtSurname.Text & "'"

Thank you so much

This was the thread I made: Link But somehow the code got seperated

Anyway thanks again, All is working fine now and now I know where I went wrong