I've spent several hours trying to debug an Access Report that is set with VBA to sort the records based on a combo box from another form. The Report's "Order By" Property does get updated but the displayed data is not sorted. The "Order By On" property is set to "Yes". The Record Source is a query. I've searched the net and Tek-Tips and couldn't find anything on this. Is it me or is this a bug? Please help if you can.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
OrderBy Property Not Sorting Report!
- Thread starter jroyce1
- Start date
ZmrAbdulla
Technical User
Did you try Sorting & Grouping when you are in the design view of the report?
Menu View > Sorting and Grouping
You can set this and override all other sorting done in the query or table
regards
Zameer Abdulla
Menu View > Sorting and Grouping
You can set this and override all other sorting done in the query or table
regards
Zameer Abdulla
- Thread starter
- #3
Thanks Zameer. I tried going to view/Sorting and Grouping and found that I had a "held down 7" - there was a hard coded sort set up on the report, so any freshly coded sorts being added to the Order By property were being overrided by this Sort Setting.
- Status
Similar threads
- Locked
- Question
