In MS ACCESS version 2003 I have a form that is based on a table. I have indicated that I want the form to display the table content in the order of the tracking id number (InvoiceNumber) which is an autonumber field.
In detail view of my form, I select the upper left corner black box properties to get to:
Form - Properties
Record Source - Table1
Order By - Table1.InvoiceN umber
As the field...