Print problem

[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.

 

[CEH]

I think you need to tell us...the sort order of what?

 

[neilmcmor]

I am looking to sort on the Surname field. However it always defaults to sort on the RegNo field which is a number field. The underlting query only sorts on the Surname field. the user can select to sort either field to sort on when viewing the form howevere the report always sorts on RegNo when printing.

 

[CEH]

Put your report in design view...go to the menu bar... select the icon for "Sorting and grouping" (should be to the right of the toolbox icon)...check the settings there.

 

[boblarson]

Reports need to have the sorting set independently of the query, as Curtis has shared. You can also find the sorting and grouping by going to VIEW > SORTING AND GROUPING when in design view.