How can I get the sort value from the sort menu?

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why can't I sort on the Column? 18
Filter a Report with a Form 2
Setting sort order from Word VBA 1
Choose sort order with hyperlink 5
Excel Excel: Sort a column with #.#.# number and keep other column 0
Retrieving data from text box and sort descending in a list 4
How to change the sort order in sub-form? 1
Cannot sort on calculated field in Query or Report 1

Top