datagrid jump to

[TheCandyman]

I have a datagrid displaying records from a Access DB. I wanted to make a small box where people could type things and it would jump to that. Like so...

user types: r

datagrid jumps down to the records that start with 'r'

I know it's possible, but not sure how to do it in VB. Was thinking of doing a quick look through the RS until the text typed in matches the Left(string1, 1) value of the RS. Thoughts? Ideas with code?

 

[KCI]

Hey,

Should work. What you will need to do is something like this:

rs.Movefirst ''' Seem to get into trouble sometimes if I don't use this
rs.Find(Left$(string1,len(trim$(string1))), 0, adSearchForward, adBookmarkFirst)

Then depending on how the grid is setup bound or unbound, sorted or unsorted you may have to set the row and toprow of your grid.

Your code should go in one of the Key events for the textbox.

good luck
KCI

 

[TheCandyman]

it is sorted by the name, so that shouldn't be a problem. Im not sure what you mean by 'bound or unbound' and how do i set the row and toprow of the grid?