I have a continuous form based on a query
This query is sorted by a different column other than the ID
I have a delete button on each record of this continuous form
The Delete button works but As I do the requery, it moves the user up to the top, loosing the place they were at.
I was thinking away around this was to get the id of the PREVIOUS record then store that. I can then use recordset clone or whatever to move back down to the record that was previous to the one I deleted.
Does this sound like something plausible?
Thanks in Advance!