Private Sub Command1_Click()
sString = txtTitle.Text
CN.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\BIBLIO.mdb"
RS.CursorLocation = adUseClient
RS.Open "SELECT * FROM titles WHERE title= '" & txtTitle.Text & "'", CN
Set DataGrid1.DataSource = RS
End Sub
the code above is pretty good but it doesnt display any record in my Datagrid what seems to be the problem.
please help;)