Seek record in datagrid
I want to be able to move the position of the recordset in a datagrid in visual basic 2005 pro. For example I have the following fields: Number, First Name, Last Name and I have a text box where I will write the last name which I want to find on the database. If if I put an S on the text box,I want the recordset to go to Smith (the first record starting with an S) so the user can see all the rest of the records starting with S and so on.
I did this before in vb6 simply with the following code:
Private Sub Text1_Change()
Data1.Recordset.Seek ">=", Text1.Text
End Sub
I used the databindings.find(Object,key) but this only finds the exact part of a field, and I want to go to the first record meeting the criteria as I write the text.
I will appreciate any help,
Thankyou
Jaime
