Change Report Sorting Using VB

[MarkEmerson83]

Can anybody tell me how to change the sorting of a report using VB code?

The situation that I would like to use this is;

I have a form with a combo box that I want the user to be able to select how they want the Report sorted. Once the sorting method is chosen the report will then be opened.

Any quick help will be greatly aprieciated.

 

[seaport]

You can sort the data in the report_open event procedure. for example,

***
me.orderbyon=True
me.orderby="Lastname, Firstname"
***


seaport