Order By never works on form

[Phil]

Hi,
I have access 2000 and for years I have never been able to get the
"form/data/Order by" property to work. It seems that no matter what I enter
in that property nothing works. I finally decided to ask why?
I've always created a queary and used the queary as the data for the form.
Can someone tell me what I'm missing about that property?
Thanks,

 

[Rick Brandt]

Hi,
I have access 2000 and for years I have never been able to get the
"form/data/Order by" property to work. It seems that no matter what
I enter in that property nothing works. I finally decided to ask why?
I've always created a queary and used the queary as the data for the
form. Can someone tell me what I'm missing about that property?
Thanks,

There is another property OrderByOn that actually activates the order based on
the OrderBy property entry. You have to set that to True and that has to be
done with code or a macro as the property isn't even exposed on the property
sheet.

For forms it is more reliable to just bind to a query and set the sort order in
the query, but if you want to apply different sorts dynamically just set both
properties and it will work.