Hmm.
I could never get the query's sort method to pass through to a report?
But in any case. I opened the form, selected the sub-report and set the order by field and it's working. Not sure why, I did this several times before i thought, although i may have just done that in the report...