Changing record source in a report

  • Thread starter Thread starter MJJ
  • Start date Start date
M

MJJ

I want to change the record source in a report so that the
report will be sorted differently.
I tried Reports!ReptName![Record Source] = Queryname but
got an error. How can I open a report with a different
source?
 
I want to change the record source in a report so that the
report will be sorted differently.
I tried Reports!ReptName![Record Source] = Queryname but
got an error. How can I open a report with a different
source?
Click to expand...

1) Any sort order in q query is irrelevant to the sort order of the
report. The place to sort a report is in the report's sorting and
grouping dialog.
View + Sorting and grouping.

2) You can change a report's record source in the report's Open event:
Me.Recordsource = "QueryName"
 
Back
Top