Orderby property

  • Thread starter Thread starter Chris McArley
  • Start date Start date
C

Chris McArley

I am attemting to set the OrderBy property on a query
definition (as opposed to using an OrderBy clause in the
SQL). While I can get the query to return the
information in the correct order in Datasheet view - if I
then attempt to use that query as a Rowsource in my
listbox it will not apply the OrderBy property. Have I
missed something.
 
Hi,

The order by query property is about its data view representation ... if
you wish it somewhere else, you put it in the SQL statement (or in the
"Sort" line of the grid).



Hoping it may help,
Vanderghast, Access MPV
 
Thanks Michel - I thought I may have been misusing it -
I'll get around it by updating the querydef.sql property
and updating that to include the valid orderby at runtime.

Thanks.

Chris
 
Back
Top