Sorting when a form opens

Please can someone tell me how I can set a form to sort A-Z on the "Name"
filed each time it opens?

Ialso need to sort a table in the same way?

Thanks

Shane

Access 2003

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Shane Nation" wrote in message
...
Please can someone tell me how I can set a form to sort A-Z on the "Name"
filed each time it opens?

Ialso need to sort a table in the same way?

Thanks

Shane

Access 2003