How to make a "Jump-back" land correctly?

[Jenny]

From form A, I select one record in a continous form and
then click on a button to jump to the other form, called
it B. When I close B, I want to see the cursor lands on
the same record I selected before the "jump". How to
control this in VBA?

 

[Ken Snell]

Assuming that the command button is part of the detail section, this should
happen automatically without the need for code. Can you give more info about
your setup?

 

[Larry Linson]

When I open a second form from a first form in Access 97, then close the
second one, the cursor is exactly where I left it on the first form. I open
the second form in the DoubleClick event of each Control in a Record using a
common function as follows:

Function OpenEmployeeDetail() As Boolean

DoCmd.OpenForm "frmEmployeeDetail", , , "[EmployeeID]=" &
Me!txtEmployeeID

End Function

How are you opening the second form? Are you closing the first form and want
to reopen it? Please clarify here in the newsgroup, not by e-mail. Thanks.

Larry Linson
Microsoft Access MVP