User selected order for report

[SueBK]

It strikes me that this should be relatively simple, but I'm just not sure how to go about it.

I have a report that consists of 5 fields, selected in a query. Depending on the user's purpose any one of those fields may be the best way to sort it.

How can I set the report so the user chooses the order it sorts in? I was thinking it would be as simple as a combo box on the form, which triggers some code on the report; but then I couldn't work out how I set a combo to allow me to choose a "field" rather than a "record".

 

[vbaInet]

Probably not as simple as you imagine it.

Are you going to give them the ability to sort in ASC and DESC for each field?

You would use the report's OrderBy and OrderByOn properties to order the report. You will need to remove any Sort you already have on the report. This is the easiest method.

 

[icbiny]

create the report with a sort order and then copy it and change sort order on each report. then just open whichever report matches the chosen sort order, perhaps with a select case or if then statement. makes a bit of clutter with all the reports but quick and simple