movenext/moveprevious

[iissa]

I am trying to create a program that will move through the record sets an access data base.
I have two buttons next, and previous.
They do move through the record sets
but
if you are on the first record set,
and press previous i get the error
and if you are on the last record set and press next i get the error.
i am currently using the movenext and moveprevious methods
is there a way of finding out if a record (+ or -) exist before actually moving to the next record.
and if there are no records in front or behind then it will give a message, saying that there are no records
any suggestions

When going forward throught your recordset you need to test for end of file if rs.eof then rs.movelast and when they hit the previous button test for beginning of file ie if rs.bof then rs.movefirst
see how that goes