Report sort in vba is breaking query update

[Stevetinkyz]

My report uses an Option Group to update a textbox that is used to filter the underlying query source.
The option group works great to filter the query, and thus the report.

I have a another option group to sort the report
me.orderby = "Deadline"
me.orderbyOn = True

The sort works too.

However, after the sort is applied, the filters will never update the report, but they do update the query and I can see that.

What am I missing here?

Extra: The sort is forever saved since it's an advanced filter, and if i go to design mode, then return to report view, i can resume using the filters with the sort applied.

Thanks!

 

[Pat Hartman]

Common misunderstanding. The report does not use the sort that is in the query. You have to change the report's sort property