Allow User To Sort Data

[thriller_1981]

Hello everyone

One of my forms has a load of data displayed in it from a query and I would like to allow the user to sort this data by means of some buttons next to each column heading. For instance clicking 'up' next to first name / last name etc will sort ascending on first name, 'down' will sort descending etc. I tried setting up different queries for each sort and changing the record source of the form in the on click event but then the controls don't seem to know where to populate from!!

Can anyone help with what I should be doing?

Thanks

 

[Pat Hartman]

This is built in functionality, you don't need to code for it. Just instruct the user to place the cursor in the column he wants to order and press the up or down arrows on the toolbar. If the user wishes to order by more than one column and they are adjacent (and you are using a datasheet view on the form or subform), he can select multiple columns by clicking and dragging. The other alternative is to use Records/Advanced filter sort.

 

[thriller_1981]

Thanks very much