I'm using the find method of a dataview to find the position of a record. As documented by microsoft, the Find method returns an integer with the index of the DataRowView that matches the search criteria. If more than one row matches the search criteria, only the index of the first matching DataRowView is returned. However, It doesn't always return the first matching index value. Sometimes it's returning the secong index value. Has anyone else experience this? I'm taking a string value from an array as my seach criteria.
strVal = aData(intRow, 0)
ojbDataV.Sort = "fullnam"
intPos = objDataV.Find(strVal)
strVal = aData(intRow, 0)
ojbDataV.Sort = "fullnam"
intPos = objDataV.Find(strVal)