Order records by field value 1

[djayam]

Hi all,

I have an Orders subform within the Customers form. All I want to do is have the Order records sorted by Orders.OrderDate DESC. I have tried entering "[Orders].[OrderDate] DESC" (without the "") and variations of but it doesn't seem to work! Any ideas?

Cheers,

Jason

 

[PHV]

I have tried entering "[Orders].[OrderDate] DESC"
Entering where ?
What is the the SQL code of the RecordSource of the subform ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[djayam]

Hi PHV,

Entered that in the Order By property of the subform.
Record Source property of the subform is simply Orders.

 

[PHV]

Either set the RecordSource property to:
SELECT * FROM Orders ORDER BY OrderDate DESC

Or put the following code in the Open event procedure of the subform:
Me.OrderByOn = True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[djayam]

You're a STAR PHV, thanks.