Go to New Record

C

chas

Hi Emmy,

here is the code created when adding a command button to
go to the next record by using the wizard. It uses basic
error trapping to leave the routine if an error occurs.

Private Sub Command22_Click()
On Error GoTo Err_Command22_Click

DoCmd.GoToRecord , , acNext

Exit_Command22_Click:
Exit Sub

Err_Command22_Click:
MsgBox Err.Description
Resume Exit_Command22_Click

End Sub

hth

chas
 
Top