[AccessD] Order By

John,

What I do if I want a form to be ordered is to use these two lines in the
Open event:

	Me.OrderbyOn = True
	Me.Orderby = "FieldName"

This lets you stay out of the recordsource field just to get things ordered.

Dan 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Thursday, February 16, 2006 12: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