sort records in the form

  • Thread starter Thread starter Shane
  • Start date Start date
S

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
 
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.
Click to expand...

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.
 
Back
Top