General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Returning to original record
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only