Order by fieilds - like Excel witin a form??

[scooble]

I have a sub form (frmApts), in continuous view within a parent form (frmDate) that contains appointment data, some of the fields are the 'Team Name' field as well as 'From' and 'To' times.

I would like to order first by 'Team Name' and then by 'From' time automatically like in the same way as you can within excel everytime I navigate to a new record on the parent form.

What code can I use to do this?

 

[boblarson]

How about setting the subform's recordsource to be a QUERY instead of the table (just select all of the fields from the table and then put in your sorting preference).

 

[John Big Booty]

This thread deals with changing the sort order of a listbox in various columns by clicking in the header row.