Move next rec

[livvie]

Does anyone know if it is possible to use code to move to the next record on a form without opening a recordset. I am trying to loop thru records on a form in code behind another form.Basically I need to mimic a key press or a click event in code.

 

[KenHigg]

pseudo

sendkey pgdn

???
kh

 

[livvie]

pseudo

sendkey pgdn

???
kh

Tricky as the form I want to move records on is already open but not the form I am using.
Also how do I enter the pgdn command as when I try it as a keystroke it just does the 'Page Down' action and moves me on to the Wait line

 

[Surjer]

its something like

docmd.acMoveNext

 

[DB7]

Hi Livvie,

As Surjer said...

Private Sub cmdNext_Click()
DoCmd.GoToRecord , "frmFormName", acNext
End Sub


...removing 2nd aRGUMENT, will move form with focus (calling form)..

Private Sub cmdNext_Click()
DoCmd.GoToRecord , , acNext
End Sub


...other constants
acPrevious
acFirst
acLast
acNew

hOPE THIS HELPS, Good luck!