Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
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