M
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?
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?