Can I pass "sort by" using DoCmd.OpenReport

[alsoto]

I have 7 different reports (slightly different layouts) all based on a simple select query. Client wants the ability to sort all 7 reports 4 different ways.



I am setting up a print menu with 2 option boxes:

Option Box "Choose Report": Report 1, Report 2, Report 3, ... Report 7
Option Box "Choose Sort By": Sort 1, Sort 2, Sort 3, Sort 4

Can I use DoCmd.OpenReport and pass the sort value so I can use the same exact select query for all 28 reports?

I also need to add a date range option for each report.

[RuralGuy]

Reports accept the OpenArgs argument.

[alsoto]

Thank you very much

[RuralGuy]

Post back here if you need additional assistance.