Setting OrderBy for a report in VBA

[Phil Hellmuth]

I want to set the OrderBy property based upon a value in an open form.
In the Report Open event, I use the following code:

If [Forms]![FormName].[SortField] = "Field1"
me.OrderBy = "Field1"
Else
Me.OrderBy = "Field2"
Endif
Me.OrderByOn = True

Though the code executes, the report sorts no differently than if the
code didn't execute. Am I doing something wrong?

Thanks in advance.

 

[Duane Hookom]

I would not rely on setting the OrderBy property. Sorting and Grouping is
more reliable when using the sorting and grouping levels. Allen Browne has
code on his site that describes how to do this
http://www.allenbrowne.com/ser-33.html.

 

[Phil Hellmuth]

I would not rely on setting the OrderBy property. Sorting and Grouping is
more reliable when using the sorting and grouping levels. Allen Browne has
code on his site that describes how to do this
http://www.allenbrowne.com/ser-33.html.

Worked like a charm. Thanks.