How to order rows on a form

[Dean Slindee]

Access 2003 .adp application using an SQL Server backend database:


On the Data tab for a form, I have specified the following in the "Order By"
property: tblJusticeClientProgram.StartDate DESC


Problem is, this specification is not honored. The Record Source is
specified as a table name: tblJusticeClientProgram


The form is used as a subform. Is there something else that needs to be
done, or perhaps Order By

does not work on subforms?

Thanks,

Dean S

 

[Tom Ellison]

Dear Dean:

What is the datatype of StartDate? Please show some values that are in this
column and the order they sort, especially where they are not sorting as
you'd like.

Tom Ellison

 

[Vadim Rapp]

Hello,
You wrote on Fri, 27 Jan 2006 21:44:19 -0600:

DS> Access 2003 .adp application using an SQL Server backend database:

DS> On the Data tab for a form, I have specified the following in the
DS> "Order By" property: tblJusticeClientProgram.StartDate DESC

DS> Problem is, this specification is not honored. The Record Source is
DS> specified as a table name: tblJusticeClientProgram

This indeed does not work in adp. Specify datasource as select * from table
order by column.

Vadim Rapp