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.

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

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::cool: