Within form, advancing to next record

[crowegreg]

I have a form that processes orders. The forms' recordset is unprocessed orders. After the user selects to process an order, if the recordset contains no more records, I'd like to display a message, and then close the form. How's the easiest way to handle this? Thank you in advance!

[June7]

I presume user clicks a button to process order? Here is one way:

Private Sub Process_Click()
On Error GoTo ErrProc
 
'your processing code here
 
DoCmd.GoToRecord acDataForm, Me.Name, acNext
Exit Sub
ErrProc:
If Err = 2105 Then
    MsgBox "End"
    DoCmd.Close
End If
End Sub

I set form properties:
AllowAdditions NO
NavigationButtons NO
CloseButton NO

[crowegreg]

Thanks. That worked perfectly!!