[AccessD] Order By

Strictly code. Make you wonder why MS exposed the OrderedBy property but not
the OrderedByOn one in the form's Property Sheet.


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


I'm going to sound totally "duh" here, but I've never heard of OrderByOn. Is
it only a code thing, or is it in the properties box?

Well, I knew it would be simple. Thanks Lambert and Dan!

>>> dwaters at usinternet.com 2/16/2006 2:29 PM >>>
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 

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