VBA to SORT (2)

[Martin]

Thanks, Allen

However, I also want to know: base on ORDERBY, how to set "A to Z" and "Z
to A" ?

Thanks!

Martin


-----------------------------------------------------------------------
DoCmd.OpenForm "ABC"
With Forms("ABC")
.OrderBy = "[Field1], [Field2]"
.OrderByOn = True
End With

 

[Allen Browne]

DESC causes a descending sort.

To sort on both your fields in descending order:
.OrderBy = "[Field1] DESC, [Field2] DESC"