To have the form sort that way, create a query into the table.
In the Sorting row under your name field, choose:
Ascending.
Open your form in design view.
Open the Properties box (View menu).
Set the form's RecordSource property to the name of the query.
The form will now sort as you requested.
Do not rely on records being sorted in a particular way in the table.
Although you can set the OrderBy property for the table (Properties box, in
table design), it is better to use the query to achieve the sorting.
BTW, if you really do have a field called "Name", consider renaming it to
something else. Many things in Access have a Name property, so Access is
likely to get confused between the field called Name and the Name of the
form, for example.
