Order By

  • Thread starter Thread starter Ice Man
  • Start date Start date
I

Ice Man

Hi all

I got a table called "payments" and it has a "duedate" field of type date
There is a form that displays the info ofthis table as a datasheet view

In form design -> datasheet view I try to put the Order by property to the
"duedate" field ... but no sorting happens.

what might be the problem

thanks
 
I normally use the Query to order the Records as per Arvin's advice.

However, if you use the OrderBy Property of the Form, you also need to set
the Form's OrderByOn Property to True to have the Form's ordering activated.

Check Access VB Help on the OrderByOn Property.
 
Thanks Guys

I used this and it worked!

Private Sub Form_Open(Cancel As Integer)
Me.OrderBy = "duedate"
Me.OrderByOn = True
End Sub


Elie H Constantine.
 
Back
Top