Hi,

I have a datasheet sub form and sort menu. If the user select Id and sorted
ascending or descending, I want to be able to know the sort selection to run
my SQL depend in the user selection.
How can I get the sort value in different form? For example, I want to be
able to read “ORDER BY ID DESC;�

I am using ms access 2003


Thanks in advance.
Mike

Hi,
you can read form's OrderBy property

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Mike" <(E-Mail Removed)> wrote in message
news:94324B49-E92D-4122-9A52-(E-Mail Removed)...
> Hi,
>
> I have a datasheet sub form and sort menu. If the user select Id and
> sorted
> ascending or descending, I want to be able to know the sort selection to
> run
> my SQL depend in the user selection.
> How can I get the sort value in different form? For example, I want to be
> able to read "ORDER BY ID DESC;"
>
> I am using ms access 2003
>
>
> Thanks in advance.
> Mike