[vb6] Database front end.
 

I'm working on a vb front end for an access database. I need to make it so that when you delete a record, it takes you to the next or previous one, rather than back to the beginning of the recordset. I also need to make it so that when you go past the place where the old record was, it never gets an error or loads a blank record.

I'm using .Recordset.AbsolutePosition to find which record I'm at, but I just don't know how to tell it which one to go to.