Move to next on not current form

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

I have a "Form1" that is Modal = True and a popup form "Popup" with Modal =
False.

When I click a command button on the form "Popup" it does a calculation on
"Form1"s current record. I would like to automatically move to the next
record on "Form1" with the form "Popup" still being the active form.

Is this possible?

Thank you,

Steven
 
the following worked for me, tested in an A2000 db running in A2003, and
calling the code from a command button in form Popup, as

DoCmd.SelectObject acForm, "Form1"
With Forms("Form1")
DoCmd.RunCommand acCmdRecordsGoToNext
End With
DoCmd.SelectObject acForm, Me.Name

hth
 
Back
Top