How do I create the facility for users to define their own sort o.

[Guest]

I have set up search form (using VBA) and want to add a facility for users to
define the order in which results are displayed. I am using Access 2000.

 

[Scott McDaniel]

Well, we don't know how you're performing your searches, but if you're
building SQL strings for searching, you can simply add an ORDER BY clause to
the SQL string. For example:

SELECT * FROM SomeTable WHERE Field1='Bob' ORDER BY SomeField

You'd present your users with a list of the fields they could choose for
sorting and build your string from there ...