How to change report sort order at run-time in access 2002

[Sifor]

Pl. guide me in above mentioned subject

 

[Alex Dybenko]

you can try this solution:
http://www.pointltd.com/Downloads/Details.asp?dlID=45

 

[Whitless]

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