Continuous subform sort

I have a continuous subform that lists all volunteers working on a given night for our haunted house, which also shows what Room, and Spot they are in. Right now it sorts by ID number, but I would like to be able to click on any of the headers to sort alphabetically by them. Ex, clicking the Worker label and have it sort Alphabetically by LastName, FirstName. The Worker field is a combobox with the following rowsource:

SELECT tblVolunteers.vID, [LastName] & ", " & [FirstName] FROM tblVolunteers;


I would also like to be able to click on the Room header and have the subform sort alphabetically by Room.

Any suggestions?
Thanks
Mike

Hopefully this may help.
It uses a listbox rather than a subform, but can be adapted easily. When the header is clicked, a different query is loaded as the record source for the listbox, and the listbox refreshed.

Dave

Thanks a lot!!! I just finished implementing it on my form and it works great!!!

ScrmingWhisprs

Glad to help.

Dave