Cursor Postion after form Requery

[GingerVA]

After researching the forums I found an answer regarding how to requery a
form using the following code:

Private Sub Form_AfterUpdate()
Dim lngpos As Integer
lngpos = Me.Recordset.AbsolutePosition
Me.Requery
Me.Recordset.AbsolutePosition = lngpos

End Sub

However, I do not want the cursor to stay with the record being updated. I
would like for it to move to a new record.

Any suggestions on how to rewrite the above code to accomplish this?

Thanks!

 

[missinglinq via AccessMonster.com]

Private Sub Form_AfterUpdate()
Me.Requery
DoCmd.GoToRecord , , acNewRec
End Sub

 

[Ofer Cohen]

Moving to new record use

DoCmd.GoToRecord , , acNewRec

 

[GingerVA]

Thank you! Worked perfectly!