I have recently been handed over maintenance of an Access "tracking system", and need to make a requested change quickly. Currently, the application loads a form (with a subform) and when the subform area is double clicked, it fires the DoubleClick event and brings up an "edit entry" form. The problem is, after the user saves the changes, and closes the entry form, the application currently does a requery and then reloads the previous form.

What the users want is for the last edited record to have focus when the form reloads. Is there a quick and dirty way that I can do this without rewriting everything?? I'm assuming that I will need to somehow save the record identifier before it loads the edit form, the perform a SetFocus on that control after the requery and form reload. Am I on the right track??