orderby= not ordering

[Guest]

I have a macro that opens a form and then sorts the data. As far as I can
tell it's not doing any of the sorting. Is there something wrong with this
code?

DoCmd.OpenForm "Events Scoring"
Me.OrderBy = "LevelPlayed, Match1"
Me.OrderByOn = True

Thanks in advance

 

[Dirk Goldgar]

I have a macro that opens a form and then sorts the data. As far as I
can tell it's not doing any of the sorting. Is there something wrong
with this code?

DoCmd.OpenForm "Events Scoring"
Me.OrderBy = "LevelPlayed, Match1"
Me.OrderByOn = True

Thanks in advance

The statements

Me.OrderBy = "LevelPlayed, Match1"
Me.OrderByOn = True

will be affecting the form on behind which this code is running, not the
form "Events Scoring" that you just opened. That's because the keyword
"Me" always refers to the object containing the code that is running.
You probably want that to be:

DoCmd.OpenForm "Events Scoring"
With Forms("Events Scoring")
.OrderBy = "LevelPlayed, Match1"
.OrderByOn = True
End With