Create a new Requery method which returns to the current record
When you requery a form after updating another form or another table, Formname.Requery goes to the first record. On a continuous form it is a real nuisance to have to return to the original record. We need a Form.RequeryReturn function to bring us back to the original record. Obviously, isf the record is deleted it should return to the previous record.
Thank you for suggesting.
As noted in the comments section there are workarounds to allow you to return to the current method after re querying.
David Harding commented
It's actually quite easy to do that already. Save the PK of the record
But requery isn't needed very often at all.
B. Clothier commented
I would point out that IMPOV, I have seen Requery abused far too many times. It is used as a shortcut to resolve discrepancy that are created the developer (e.g. running query against the same source the form is based on). If the Requery is creating more problems, then it's very likely that it's a wrong solution to the problem and one should look for different solution (e.g. using Form.Recordset to do in-place updates as an example).
Good idea. And requiring ... no code :-)