Order Form (1 Viewer)

[Vulcan1500]

To print a report to the screen I'm using following statement:

DoCmd.OpenReport strDocName, acPreview, strWhere

Where and how can I order the report? I would like to order on more then one column.

 

[stopher]

You'd normally set the sort order for the report in the report design view (prior to using it).

But I'm guessing you want to set the sort dynamically? I guess you can add some code to the On Open event for the report that gets the sort order from someplace e.g. a form, and then sets the report sort order accordingly.

hth
Chris