Sort a query by different fields deepening on user input.
Posted on 2014-01-08
I have a query that has fields A, B, C, and D. The query populates with data when opened and sorts by field A in ascending order. I have an option box that has two buttons on the form. When the user click B i want the query to update and sort ascending on field B. Or if they desire they can pick the A button to sort ascending on field A. What is the best way to accomplish this?