OK, fellas, I am trying hard to guess what is up here
But it is hard to get why is new record would be previous
One suggestion is that when you .MoveLast - you are checking recordset out to the last record and then
If Not Rs(0)
.MovePrevious could do something.
You can also post way you opening Recordset, could be problem there
TIA