Soting question on Query to form

Hello;

I want to add a menu a form with different sort by options, what would be
the best way to do this? They choose the data order and select a button to
run a report which sorts the data as they have specified thru a query.

Example:
Field choices: Date, Name, Address, Phone, zip
1. Date
2. Name
3. Addy
4. Phone
5. Zip

or

1. Zip
2. Name
3. Addy

and so on?

Thank you.
Lou

Set up a form with however many combo boxes you need. Each combo box contains
the list of possible sort by fields. Have a SORT button to run the sort;
this button will open your form passing in openargs a string representing the
sort order. In your form open event, you unparse this string and use it to
set up the SQL for the record source of the form.

-Dorian

"LOU" wrote:

Hello;

I want to add a menu a form with different sort by options, what would be
the best way to do this? They choose the data order and select a button to
run a report which sorts the data as they have specified thru a query.

Example:
Field choices: Date, Name, Address, Phone, zip
1. Date
2. Name
3. Addy
4. Phone
5. Zip

or

1. Zip
2. Name
3. Addy

and so on?

Thank you.
Lou