Report sort in vba is breaking query update

Stevetinkyz

New member
Local time
Yesterday, 19:03
Joined
Aug 10, 2023
Messages
1
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!
 
Last edited:

Users who are viewing this thread

Back
Top Bottom