N
Norbert
How do I keep the same page of a continuos form (frm1)
after refresh from a form (frm2) opened by frm1?
Enclosed is the code I am using to go back to the prior
record but this record shows up in fop of the screen in
frm1. For example if the record was in the 5th position it
will jump to the 1st position in the screen.
Code in frm1: cmdAppt_Click()
DoCmd.OpenForm frm1, , , "ApptID=" & me.ApptID
Forms!frm2!txtBackToRecord = Me.CurrentRecord
Forms!frm2.SetFocus
Code in frm2: cmdSave_Click()
With Forms!frm1
.SetFocus
!cmdAppt.SetFocus
.Requery
DoCmd.GoToRecord acDataForm, "frm1", acGoTo,
Me.txtBackToRecord
End With
Thanks
Norbert
after refresh from a form (frm2) opened by frm1?
Enclosed is the code I am using to go back to the prior
record but this record shows up in fop of the screen in
frm1. For example if the record was in the 5th position it
will jump to the 1st position in the screen.
Code in frm1: cmdAppt_Click()
DoCmd.OpenForm frm1, , , "ApptID=" & me.ApptID
Forms!frm2!txtBackToRecord = Me.CurrentRecord
Forms!frm2.SetFocus
Code in frm2: cmdSave_Click()
With Forms!frm1
.SetFocus
!cmdAppt.SetFocus
.Requery
DoCmd.GoToRecord acDataForm, "frm1", acGoTo,
Me.txtBackToRecord
End With
Thanks
Norbert