Macro automatically runs report

One possible simpler solution would be to pass the current forms filter property to the report and apply it there. This isn't something that I use, so I didn't test it, but here are the ideas.

Filter Property
http://office.microsoft.com/en-us/access-help/filter-property-HA001232736.aspx

OpenReport Method
http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx

The only issue is passing only the filter will not do in itself what you want. You have to pass the OrderBy property also and add it to the report.

Hope this helps,

Dan