How to order rows on a form

  • Thread starter Thread starter Dean Slindee
  • Start date Start date
D

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
 
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
 
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
 
Back
Top