A Alex Dybenko Jan 11, 2005 #2 you can try this solution: http://www.pointltd.com/Downloads/Details.asp?dlID=45
G Guest Jan 11, 2005 #3 There is code you can place into the Report_Open event that will allow you to sort at "run-time". http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/acprosortorder.asp This talks about the sortorder property. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/acobjgrouplevel.asp This talks about the grouplevel property. The example shows how to apply the sort order to a specific grouplevel in the report_open event. I hope this helps
There is code you can place into the Report_Open event that will allow you to sort at "run-time". http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/acprosortorder.asp This talks about the sortorder property. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/acobjgrouplevel.asp This talks about the grouplevel property. The example shows how to apply the sort order to a specific grouplevel in the report_open event. I hope this helps