Reports ignore the sort order of the record source. You MUST open the report in design view, specify the desired sort order in the Sorting and Grouping windows, then save the report design. Does that fix your problem?
(If the report displays the records in the desired order without having specified it in the Sorting and Grouping window, it is by accident, you can't rely on it, as you have found.)
I knew that!
The following in Report_Open quickly sovled the problem
Me.RecordSource = gloGetValue("ReportRecordSource")
Me.OrderBy = gloGetValue("OrderBy")
Me.OrderByOn = True
PS: Your not going to believe what I have been getting away with for over two years.
The way this was working for me in the past was to build a tblResultsBP file of the autonumber