This can’t be true. When a form opens, all the formulas in all the objects are evaluated at that time, and if they weren’t, there would be no result showing at all. It definitely has no memory of what it was displaying the last time the database was open. I think you are probably doing a Select, after the form opens, and that’s not triggering the .CurrentRecord procedure.
If you have a procedure that is doing the select, have that same procedure do the Show or ShowPage right after the Select.
The documentation is on page 396 of Formulas & Programming.
The ..ActivateForm event handling procedure is triggered when any form in the same database as the procedure is activated (brought to the front). It doesn’t matter how the form is activated—manually (by clicking on it) or as part of a procedure (usually the window statement).
Since this procedure is activated when the form comes to the front, rather than after the select, it’s not any help.