open report with form sorting

  • Thread starter Thread starter 1aae
  • Start date Start date
1

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
 
1aae said:
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
Click to expand...

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.
 
Back
Top