ORDER BY clause in StrFilter of OpenForm

[raktims]

How can I use ORDER BY clause in the strFilter criteria of OpenForm function.
Thanks in advance.
Raktim

Code:
If strFilter <> "" Then
strFilter = Right$(strFilter, Len(strFilter) - 5)
strFilter = strFilter & " ORDER BY CreateDt"
End If

Error:
'Syntax Error (missing Operator) in query expression 'ResID = 10 ORDER BY CreateDt'

 

[pdx_man]

You need to use the form's OrderBy property.

Me.Filter = Right$(strFilter, Len(strFilter) - 5)
Me.OrderBy = "CreateDt"

Me.FilterOn
Me.OrderByOn

 

[raktims]

Thanks very much. It worked.