How to jump to a specific row in grid

Legacy Contributor

Currently the Collection Navigate only has 4 types (previous, next, top and bottom) of navigation. I am thinking of using VB script to write a code so when a user click a button, the grid will jump to a specific line. But I still don't know how to implement this navigation function. Any suggestion would help.

dean-bradko

You can search through the collection and then set the focused row to the row number of the located value.

For i As Integer = 0 To ThisForm.PrimaryIDOCollection.GetNumEntries - 1
      If ThisForm.PrimaryIDOCollection(i).Item("Some Field").Value = "Some Value" Then
           ThisForm.PrimaryIDOCollection.SetCurrentObject(i)
           Exit For
      End If
Next i