hello,
i have a datagrid and i would like to be able to search the record in the datagrid

the problem is the search, how can i search a single keyword
then all the matching keyword will shown up.



Set RS_Login = New Recordset
RS_Login.Open "select * from log where username = '" & Text1.Text & "'", cnnLogin, adOpenDynamic, adLockOptimistic
If RS_Login.EOF Then
MsgBox "record not found"
Else
End If
Set DataGrid1.DataSource = RS_Login
DataGrid1.Refresh