How do i use the Recordsource Property of the report in MS-Access?

Question

Hi I have to set the Recordsource property of a Report in Access at runtime. However when i run the code. Its giving me a runtime error '2191' saying "You cant set the Record Source property in print preview or after printing has started.

Kindly let me know how do I set the recordsource property at runtime

Regards,
Vikram.

Answer 1

If I recall correctly, setting the property on the Report_Open() before the page is rendered is possible. If that does not work set the Recordset property (with an ADO.Recordset)