Printing

[neilmcmor]

I am printing a report form a button on a form using:-

DoCmd.OpenReport stDocName, acNormal

However I cannot get the sort order right. i have tried setting the sort order in the reports properties and also the underlying query but to no avail. How can I force the sort order from the print button? Any help appreciated.

 

[petehilljnr]

Are you able to get the order correct in the query? e.g. using the AZ sort button on the tool bar, or even the sort ascending/descending in the QBE grid?

I'd start there because if you can't sort the query correctly, you won't be able to sort the report either.

Pete

 

[DCrake]

Simple Software Solutions

I don't usually partake in report threads, however one other check it so design the report and click on the indexes/grouping icons on the tool bar and check to see what orders are in force there.

CodeMaster: