dataview / datagrid row pointer

[lauriemc]

I am using the following code to filter my datagrid's results. The batch number is entered in a text box and then on the keyup event, it fires off the following code:

 

Dim Hold_Search As Integer

Dim Hold_Field As String

 

Hold_Search = Me.txt_BatchNumber.Text

Hold_Field = "BatchNumber"

 

DvBatch.RowFilter = Hold_Field & " = " & Hold_Search

DvBatch.Sort = Hold_Field

 

It does what it is supposed to do, but the problem is I really don't want the data 'filtered'. What i want is for the datagrid to scroll to the valid row and then keep scrolling based on the client's input until the desired value is reached - but without the filtering or winnowing out of the data.

 

I hope this makes sense. Can anyone help me ?

 

laurie mc

[techmanbd]

I ddn't get a chance to test it, but maybe this will help

 

DvBatch is your data view correct?

DvBatch.Find(Hold_Search)

[lauriemc]

The "Find" wants a sort previous to it. So now when I do it like this:

 

DvBatch.Sort = Hold_Field

DvBatch.Find(Hold_Search)

 

what it seems to be doing is only sorting, but it points the column to the very beginning and then doesn't budge on subsequent key strokes.