James,

>Ok, where is the index of the newly active row? Is there such a thing?

RelativeRow, but that won't change if you are on the last row. ActiveRow is horribly slow on large tables so you should avoid it unless you are looking at small recordsets.