open report with form sorting

[1aae]

I have form and report
i have button in a form to open report
is there any way to open the report with sort order of the form?
with out using order by or order by on methods..
thank you

 

[Dirk Goldgar]

I have form and report
i have button in a form to open report
is there any way to open the report with sort order of the form?
with out using order by or order by on methods..
thank you

Not that I can think of. I could conceive of using code in the report's
Open event to pick up the Order By property of the form and use it to
set the report's OrderBy property -- but you say you don't want to do
that. Note also that any Sorting and Grouping that is specified in the
report design will override the report's OrderBy property.