Your code is trying to delete a recordset, which probably doesn't work. Probably a few other issues as well, such as the lack of criteria in the find method and not testing for "no match" before trying to edit/delete anything found. Either calling a delete query in your code or opening the recordset for edits or creating delete sql in code would work. If the records are shown in a form, navigating to the last record would be the best of all IMO.
Lastly, trying to modify a record using any find method is risky if the records are not explicitly ordered by you. You should not rely on their positions as seen in an open table.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.