Don't base your form directly on the table, but base them on a query which
is sorted the way you want. In the RecordSource property of the form (in
Design View), click the builder button [...] to the right. This will bring
up the Query Builder. Add all your fields to the query (or just the *) and
sort it the way you want. Then close the builder and save the form.
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?