How to order rows on a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dean Slindee - 28 Jan 2006 03:44 GMT

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

Reply to this Message

Tom Ellison - 29 Jan 2006 00:34 GMT

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

> Access 2003 .adp application using an SQL Server backend database:
>
[quoted text clipped - 12 lines]
>
> Dean S

Reply to this Message

Vadim Rapp - 29 Jan 2006 14:59 GMT

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

Reply to this Message