Me.FilterOn = True - loses sort order

[Stapes]

Hi

I have a form that displays a load of records on asecending account
number sequence. I added a filter to enable the user to selectively
only process one group at a time. However, the sort order is lost.

I use these commands to set the filter on:

Me.Filter = "((Lookup_Combo26.TXT_Main_Abriv = '" & Combo38 & "'))"
Me.FilterOn = True

And the record source of the form:

SELECT Temp_Demoters.*, Temp_Demoters.AcNo
FROM Temp_Demoters
WHERE (((Temp_Demoters.Done)=No))
ORDER BY Temp_Demoters.AcNo;

Is ther any way I can preserve the sort order?

Stapes

 

[Allen Browne]

Try adding:
Me.OrderBy = "AcNo"
Me.OrderByOn = True