Help On MOVE NEXT

[baby]

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

[swatty]

You have to test on these before doing a

adodc1.recordset.movenext

Instead write it like

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

[kinjalgp]

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

Kinjal