sort vs orderby

Hello everyone

I have used both OrderBy and acCmdSort to sort both ascending and descending
on various fields in a form. I personally prefer using OrderBy because i
don't have to move the focus to the desired field before sorting. But i was
wondering, is there any difference or any benefit of using one over the other?


Thanks

Manny


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200508/1

If you always want the form sorted in a particular way, the most efficient
solution is to use a query as the form's RecordSource, and specify the
sorting there.

The OrderBy is simplest way to alter the sort order on the fly; you can do
that regardless of what field has focus, specify a combination of fields,
easily handle subforms, and even set the OrderBy of a form that does not
have focus.

The RunCommand is the least useful approach, as it does depend on what has
focus.

Unfortunately, these is a bug if you set the Filter/OrderBy for both the
main form and the subform both. Details in:
Incorrect filtering
at:
http://allenbrowne.com/bug-02.html
This problem applies no matter how you set the filtering or sorting.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Manuel C via AccessMonster.com" wrote in message
...

I have used both OrderBy and acCmdSort to sort both ascending and
descending
on various fields in a form. I personally prefer using OrderBy because i
don't have to move the focus to the desired field before sorting. But i
was
wondering, is there any difference or any benefit of using one over the
other?

Allen:

Thanks for the info. I was not aware of these bugs, i will try to avoid them
as i continue to learn about Access.

Manny


Allen Browne wrote:
If you always want the form sorted in a particular way, the most efficient
solution is to use a query as the form's RecordSource, and specify the
sorting there.

The OrderBy is simplest way to alter the sort order on the fly; you can do
that regardless of what field has focus, specify a combination of fields,
easily handle subforms, and even set the OrderBy of a form that does not
have focus.

The RunCommand is the least useful approach, as it does depend on what has
focus.

Unfortunately, these is a bug if you set the Filter/OrderBy for both the
main form and the subform both. Details in:
Incorrect filtering
at:
http://allenbrowne.com/bug-02.html
This problem applies no matter how you set the filtering or sorting.

I have used both OrderBy and acCmdSort to sort both ascending and
descending
[quoted text clipped - 3 lines]
wondering, is there any difference or any benefit of using one over the
other?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200508/1