Changing recordsource on a open report.

L

Lars Pedersen

Is it possible to change an open reports recordsource, I am trying to do so
with an sql statement from a "filter report" - form. but I get an error
2191, saying that it can not be done.

/Lars
 
B

Brendan Reynolds

To the best of my knowledge, no, at least not without closing and re-opening
the report. I believe the only event in which you can change the record
source of the report is the Open event.
 
Top