Resort Order in a Form

S

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.
 
K

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.
 
Top