>Check your in box.
Thanks Marcia (and Tore).
It seems that I haven't really explained myself properly as this isn't what I'm looking for. I don't want the user to sort things in the grid by dragging the rows (although that may come in handy elsewhere). I want the user to be able to sort the entire contents of the grid by specifying which columns to sort on.
So If I have a grid showing the following columns:
Company, Department, Surname
I want the user to be able to sort the grid by:
Company + Department + Surname
or by:
Department + Surname
or by
Surname
or by
Surname + Company + Department
or any other possible combination.
I was envisaging this as letting the user to (to get the Company + Department + Surname order) click on the Company column header, which will then sort the grid by Company, then they can Ctrl+Click on the Department header which will set the order of the grid's recordsource to Company + Department and then they can Ctril+Click on the Surname column header and the full sort order will get set to Company + Department + Surname.