Help On MOVE NEXT

hi guys

a simple question..... i created a form WITH link to access DB and i created a button call Next in it i wrote adodc1.recordset.movenext



then everytime when i press next until the very last and i press again it will give me a EOF OR BOF error pls help:)

You have to test on these before doing a

VB Code:

adodc1.recordset.movenext

Instead write it like

VB Code:

if not adodc.recordset.EOF then
     adodc1.recordset.movenext
else
     ' place it back at the beginning if there is one
    if adodc.recordset.recordcount then
         adodc.recordset.movefirst
   end if
end if

Everytime the button is pressed check if adodc.recordset.EOF is true before proceeding further eith the adodc.recordset.movenext :D

Kinjal