Resort Order in a Form

[Sorting in a Graph]

What is the best way of reordering records in a form? This would be across
multiple columns in the table vs a single column on the form that I could hit
the Sort Descending/Ascending button on the main menu.

 

[KARL DEWEY]

One way is to put sort selection check boxes in the header of your form and
have it refresh/requery when a selection is changed.
In the query have criteria for the sort selection and your sort field.
Create a query for each different sort. Put these in a union query as your
source. Only the one that matches your sort criteria selection will output
records.