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

  • Thread starter Thread starter Jenny
  • Start date Start date
J

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?
 
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?
 
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
 
Back
Top