When you 'sort' a Table, you're actually only telling Access how you want to see the data in Table View, i.e. when you're looking directly at the Table, but the underlying data, in the Table, remains in the same order as it was before you sorted it, and this is how it is seen by the Form that is based on the Table.
Many of us prefer to base Forms on Queries, even when we're only using a single Table. You can then sort the data, in the Query, however you want, then base your Form on the Query.
Second option is, in Form Design View, set the Form's Order By On Load Property to Yes, and set the
Order By Property to the Field you want to sort by, including Square Brackets around the Field Name. So:
Order By On Load: Yes
Order By: [FieldNameToSortBy]
If you want to sort on Multiple Fields:
Order By: [FirstSortFieldName],[SecondSortFieldName]
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007