Morning all

When a record is saved on one of my forms (this is a view), the view is also requeried, taking the RECNO back to the top.

I have input some code to hold the current RECNO of the amended record and after it's been requeried, it will go back to that RECNO.

BUT...Because the view is ordered by date, if a record is amended, and then the view is requeried, the original RECNO will be insignificant because the views order would have changed, therefore changing the RECNO's.

Can anyone give me some idea on how I can work around this (apart from using the PK of each view which I would rather not do because there are quite of a few of them).

Thanks
Kev