Changing sort order of a form

[Mike Janes]

I have a "Personnel" form whose primary key is an AutoNumber. Thus,
the form cycles through the records according to their number.

Is there an easy way to change the sort order? I would like to have
the records sorted alphabetically by their Last Name. The only
solution I can think of is making a Querie based on this table,
changing the Last Name's "sort" field to "ascending" - and then go back
to the form and change each command so that its Control Souce points to
the field in the querie, rather the original table.

Is there an easier way?

 

[Guest]

Open the form in design view and view properties. The Record Source should
begin SELECT and end with a semicolon.
Insert this just before the semicolon --
ORDER BY [YourLastNameFieldName]

 

[Jerry Porter]

You should also be able to enter the Last Name field in the Order By
property in the form's design view.