i have a table1( trno, doc,docno)

1    dr       dr123
2    dra      dra123
3   dr         dr 124  


i have a button that has movenext and moveprev

in my sql ---select * from table1 where docno='dr124'

how can i simulate like in databinding --
when i click moveprev it will find 'dr123'  ?

then  movenext    it wll find dr124 agen

my prev code is to load in my dataset this sql ---select * from table 1 where doc='dr' and have the binding source but the data is huge.
instead of this.

inside movenext or move prev is i will insert those sql

tia

now  have  this code fro moveprev

SELECT TOP 1 *   FROM TABLE1 WHERE

TRNO<@TRNO
ORDER BY TRNO DESC

for movnext

SELECT TOP 1 *   FROM TABLE1 WHERE

TRNO>@TRNO
ORDER BY TRNO DESC


any comments on this?
tia