I have a report based on a qbf (dynamic query). The query includes an OrderBy that sorts by EndDate, Priority or ProjectName based on user selection on a form. The sort order is correct in the query. The report based on that query has no Sort order stipulated either in code or in the Sorting//Grouping option but always sorts by priority. Any ideas?

roperts are sorted by the "Sorting and Grouping" icon regardlkess of the report RecordSource ordering.

Thanks for the reply but there is no sort order specified in the sorting and grouping "Icon". There is no specification at all in the report either in code or in the provided options. Thats why it should be defaulting to the query sort order. Really confused as to why this is happening. Tried building a new report from design view (no wizard) also and no help. Any ideas?
Thanks,
Jerry

I think that the "sorting and grouping Icon" controls for reports, regardless of the report recordsource or not. If no "sorting and groupoing is specified, you'll get the recordsource table default order.

None is specified so I should get the recordsource sort order. In this case a query not a table. The table is ordered by an AutoNum field and the query by Priority or date or name depending on user selection. Anyway I took the cheap way out and made 3 reports with the correct sorting and called them as appropriate but I really hate doing it that way. Any other ideas?

I know that sort order and grouping can be dynamically set. I'll have to look up how.

I was looking for that also. Best I could find from the developers handbook was Me.GroupLevel(0).SortOrder = "Whatever" but I am not using Grouping and could not find a similar property for the entire report. Also tried OrderBy in the open event to no avail.
Thanks,
Jerry

Getz, Litwin & Gilbert's Access 2000 Developer's Handbook, Volume 1: Desktop Edition has a section on "Controling Sorting and Grouping" via VBA.

"Best I could find from the developers handbook was Me.GroupLevel(0).SortOrder = "Whatever"
Ch.9 pg:662