How do you sort in a query using Value list as Row Source Type

[Guest]

Hello,
I have a query and I am using "Value List" as "Row Source Type". How do you
sort it?
Example:
My "Row source" is:
File Name; Size; Date Modified; c750001; 23456; 07/01/2005; t123400; 4566;
07/25/2005; c100200;125001; 07/29/2005;
Thanks!!

 

[John Vinson]

Hello,
I have a query and I am using "Value List" as "Row Source Type". How do you
sort it?
Example:
My "Row source" is:
File Name; Size; Date Modified; c750001; 23456; 07/01/2005; t123400; 4566;
07/25/2005; c100200;125001; 07/29/2005;
Thanks!!

If you're using a value list, you must simply sort it manually. I take
it this combo has three columns?

Why not enter this data into a Table, and base the combo on a sorted
QUery based on the table? Especially if the values will need to be
edited, or new values added, it'll be a lot simpler to manage.

John W. Vinson[MVP]