Finding record location in a dataset

[ElPresidente]

Hi everyone,

I've successfully connected to an Access database and stored the SQL
query results into a dataset table. My question is how can I look up
the row location of an item in the first column?

Say the first column is Customer Number and the second column is
Expense code. I'm looking for some code that will let me say that
customer number "12345" is in row 5 so I can then access the
corresponding expense code.

Thanks

 

[ElPresidente]

I tried using DataView but Find requires that the list be sorted. So
when I try that index number on the original table, I get the
incorrect item.