Changing record source in a report

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?
 
F

fredg

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"
 
Top