Missing Operator

[tagheuer34]

hello!!! newbie here....i also have this problem. my code goes like this...

Private Sub cmdSearch_Click()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
 
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\contact.mdb;Persist Security Info=False"
 
Set rs = cn.Execute("SELECT * FROM Table1 WHERE Contact ID = '" & txtContId.Text & "'")
 
DataGrid1.DataSource = rs
 
DataGrid1.Refresh
End Sub

what i want for this code is to search for a particular record that will be inputted in the txtContId.text and then show the other contents of that record in a table form in the datagrid1.

but instead in gives an error "operator missing".

Please help me....God bless