Carrying over sort to report

[eww]

I've got a continuous form that opens basically as a report layout. It has print preview button on it that takes the user to a preview of a report representation of the data. In the code for this button I have already made it so that any filters put on during the form view would be carried over when the report is opened i.e.

DoCmd.OpenReport "rptBacklog", acViewPreview, , Me.Filter

However I found out that this of course doesn't carry over any sorts. I was wondering how to carry that over as well. Is it as simple as "Me.OrderBy"? If so, how would I lay it out? This doesn't seem to be quite right:

DoCmd.OpenReport "rptBacklog", acViewPreview, , Me.Filter & Me.OrderBy

Thanks.

[jgelpi16]

I'm not sure about OrderBy. Could you not just add a field to your table called "Sort" and have that an autonumber field or something, then just sort by that field for everything? That would keep your sort universal.

[eww]

From what I've seen there's not an easy way to carry over an open user defined sort. You can do it if you know what's being sorted, however it can't work the same way as my filter statement currently is. I'm going to go back to the drawing board on my reports and add quite a few features later to get around this.