Sort table by clicking on field heading?

M

Mike Collard

I have a form with the default view set to Datasheet.

How can I sort the data displayed by clicking on the field
heading?

Thanks

Mike Collard
 
A

Allen Browne

Are you aware that you can right-click the heading over the datasheet
column, and choose Sort Ascending?

If that is not satisfactory, you might switch to Continuous Form view so you
can use the Click event of the label in the Form Header, so set the OrderBy
property of the subform (remembering to turn OrderByOn on as well).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

datasheet view - sort upon clicking on column heading 2
undo sorts button 2
Custom Shortcut Menu Not Working For Datasheet Columns 10
Subform Sorting Problem 1
Sort form records by field looked up in another table 1
Using Check Boxes to select items in an Access subform. 0
datasheet: ¿how to order by the 2nd column of a combobox? 1
Sort datasheet subform by column with command button on main form 1

Top