Order By

[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

 

[Arvin Meyer]

Base you form on a query with your table as its data source. Use the field
in the query to sort on.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Van T. Dinh]

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.

 

[Ice Man]

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.