[AccessD] Finding the sort order on a datasheet. UPDATE: And then loading it'

John,
Try this:

    Forms("frmName").OrderBy = "tblTableName.FieldName"
    Forms("frmTest").OrderByOn = True

Regards
borge

---- Original message ----
>Date: Thu, 30 Aug 2007 00:46:03 -0400
>From: "John Skolits" <askolits at nni.com>  
>Subject: Re: [AccessD] Finding the sort order on a 
datasheet. UPDATE: And then loading it'  
>To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
>
> 
>OK, so I can get the "order by" info, but when I try to 
push that info into
>the datasheet's OrderBy property, it doesn't seem to change 
the view.
>After I set the property, I tried doing a Forms!
frmName.refresh (or requery)
>and the form doesn't change. 
>The info is in the property but it doesn't refresh. Is 
their a property of
>the form that is something like the AllowOrderBy?
>So, how can I get the form to refresh after I set the 
OrderBy value?
>
>
>John Skolits
>
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
John Skolits
>Sent: Wednesday, August 29, 2007 11:40 PM
>To: 'Access Developers discussion and problem solving'
>Subject: Re: [AccessD] Finding the sort order on a 
datasheet.
>
>Duh!!!
>
>Well, I hope no one else sees this question!
>
>John 
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
pcs at azizaz.com
>Sent: Wednesday, August 29, 2007 11:00 PM
>To: Access Developers discussion and problemsolving
>Subject: Re: [AccessD] Finding the sort order on a 
datasheet.
>
>Hi John,
>What about
>
>Forms!frmName.OrderBy
>
>Regards
>borge
>
>
>---- Original message ----
>>Date: Wed, 29 Aug 2007 22:38:21 -0400
>>From: "John Skolits" <askolits at nni.com>
>>Subject: [AccessD] Finding the sort order on a datasheet.  
>>To: "'Access Developers discussion and problem solving'" 
><accessd at databaseadvisors.com>
>>
>>
>>I have a form that is displayed as a datasheet. If I do
>some filtering, I
>>can get the filter by
>>"Forms!frmName.filter"
>>
>>But, what if I sort descending or ascending on a field? Is
>there anyway to
>>get that info? Is there a property of the datasheet
>like "DatasheetSort"?
>>
>>John Skolits
>>
>> 
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>--
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>>
>>No virus found in this incoming message.
>>Checked by AVG Free Edition. 
>>Version: 7.5.484 / Virus Database: 269.12.1/963 - Release
>Date: 8/20/2007
>>5:44 PM
>> 
>>
>>--
>>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
>
>--
>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