[AccessD] Order By

John,

I think you'll find that you also have to set the OrderdByOn property to
True before the OrderedBy property has any effect. Simplest thing would to
do that in the OnLoad event... Me.OrderedByOn = True

Lambert


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Thursday, February 16, 2006 1:47 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Order By


I ran into a slight problem today. I've gotten passed it, but I am still
curious.

I designed a form and tried putting into order by a control number. To do
this I figured I had to add it to the "Order By" property of the form.
However, this did not give me any results. What I ended up doing, in the
essence of time, is put a SELECT statement in the Control Source of the
form, ending in an Order By statement.

Why wouldn't this work the first way?

John Clark
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com