A subform's sort spec is stored with the parent form's sort spec. So with the parent form open, you'll want to set whatever sort spec you want for the parent form and then go to the sort spec for the subform and set it. Then bring up Spec Manager, save the spec and set it as the default sort spec. No programming needed.

-Ray

I've tried a few different methods but the only way I can get the sort to work is to do a search to pull up a result set in the parent form go to a record where the work subform has a few different subrecords, then go to my sort spec select "sort work" then click on the sort button for "work_date" change it to "descending" then click "run spec" or if I manually load the spec I've saved "Work_Date_Descending" and then manually click run spec. Setting as default doesn't do anything. I can't/don't need to set any specs for the parent form. Just for the work subform right now. I tried using the programming to get the sort spec to run and had some success. I  got the sort spec to actually load and I could see that it was loaded and all I would have to do is to click "run spec" but it wasn't running the spec automatically with the "RunSortSpec()" command. However, I would get prompted automatically on retrieval of the ResultSet that it was modified and would I like to continue, then when running the spec I would get the same prompt, so two click-throughs to run a sort spec. I'm also now running this programming from the parent form On Form Entry for Update Mode, instead of from the Work subform's programming, so maybe that's the problem. I read through the spec commands in the programming guide and read through the sorting section in the user guide and I still can't figure out how to get this to sort automatically with minimal user input.

Ok thanks I'll try that.