Hey guys,
I have a continuous form that looks like this:
We don't like to delete our names here, so instead of actually deleting a record, my delete button just marks the linked field [Deleted] with an "x". The vba code for the delete button marks the field as "x" then requeries. Which will remove it from view. Each time the form is requeried, though, the first record is selected. So if a user is deleted the 105th and 106th records, he has to scroll way back to where he was each time.
How can I add a blurb of code that gets the record number of the 1 directly before the deleted one, mark the desired one as "x", requery, then goto that previous record?