John Henry

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.

__________________
"No one was behaving from very Buddhist motives. Then, thought Pigsy, he was hardly a Buddha, nor was he a monkey. Presently, he was a pig spirit changed into a little girl pretending to be a little boy to be offered to a water monster. It was all very simple to a pig spirit."