>>>>>>>>>>>>>>>>>>>>>>
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).
>>>>>>>>>>>>>>>>>>>>>>
If I understand you correctly, there is no easy way because voews are really SQL SELECT statements (queries), so they work as sets. Therefore any requery will most probably change your recnos (unless the result set is exactly the same. I'd go with the PKs as you said.