D
Dean Slindee
I have two Access 2003 front-end applications with SQL Server 2005
back-ends. Both have a Client table/form as the root table/form. Both have
child tables/forms appearing within tab pages embedded within the main
Client form.
Both main Client forms have the Record Source property set to the (root)
Client table within their respective databases.
Both main Client forms have the Order By property set to "LastName,
FirstName, MiddleName", which are valid columns in the Record Source table.
In one application the Order By is honored, and in the other it is not.
Where it is not, the rows are shown in the physical sequence of the Client
table. I have made all property values the same in both Client forms, to no
avail.
Can anyone suggest where to look to find what might be overriding the Order
By property (or why it's being ignored) on the Client form where Order By is
not being honored? Is there some application level parameter?
Dean Slindee
back-ends. Both have a Client table/form as the root table/form. Both have
child tables/forms appearing within tab pages embedded within the main
Client form.
Both main Client forms have the Record Source property set to the (root)
Client table within their respective databases.
Both main Client forms have the Order By property set to "LastName,
FirstName, MiddleName", which are valid columns in the Record Source table.
In one application the Order By is honored, and in the other it is not.
Where it is not, the rows are shown in the physical sequence of the Client
table. I have made all property values the same in both Client forms, to no
avail.
Can anyone suggest where to look to find what might be overriding the Order
By property (or why it's being ignored) on the Client form where Order By is
not being honored? Is there some application level parameter?
Dean Slindee