Sort a report from fields on a form

[btrini10]

Hi
I have three variables, sort1, sort2 and sort3 which are entered by the user via a form. Each combo box allows the user the same 4 options by which to sort a report. Sort1 has a default value, so if nothing is selected, I want the report sorted by that field. Otherwise, sort1 is the primary sort, sort2 is the secondary and sort3 further sub sorts. Can someone help me translate this into VB code?

 

[btrini10]

Can anyone lend some assistance on this issue.
Thanks.

 

[dhookom]

Allen Browne has code at

http://www.allenbrowne.com/ser-33.html

which describes how to dynamically sort a report at run-time.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]