In Access2000, I have a form which contains four different fields which our
shipping department utilizes. Publisher, Author, Location and Carton. The
shipping manager has requested that he be able to sort the form by each of
the fields individually by pushing a command button. For example, he may
one day push the command button labelled "Sort By Publisher" and have a
report appear, sorted by publisher. Another day, he may push the command
button labelled, "Sort By Author" and have a report appear sorted by author.
I have already replaced the header labels with command buttons.
My question is: How can I set up the form so that once the command button
on each of the fields is pushed, the sorted report will appear?
Thanks in advance,