sort records in the form

[Shane]

Hi,

I am trying to sort records based on the count of the
records in the form in Access2000. The Record Source is
getting data from a view. Since we have SQL Server 7.0
with db compatibility 65, I am not able to sort record in
the view level. So I use the 'Order by' function in Access
in the form level with DCount function, but for some
reasons, it doesn't really response this action. Any one
has any idea what is the reason?

Any help would be greately appreciated!

Thanks,
Jane

 

[John Vinson]

So I use the 'Order by' function in Access
in the form level with DCount function, but for some
reasons, it doesn't really response this action.

Frustratingly, you must ALSO set the OrderByOn property of the Form
when you set the form's OrderBy - it doesn't set automatically and it
isn't on the list of properties in the user interface, it must be set
from code.