-
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
Code:
if rs.eof then rs.movelast
and when they hit the previous button test for beginning of file ie
Code:
if rs.bof then rs.movefirst
see how that goes
