Hi,
i'm working on an access project and i'm trying to build a report based on an SQL statement and assign it to the report in VB using:
Report_ReportName.RecordSource = "SQL statement"

but when i try to execute it i have this run time error: "you can't set the record source property after printing has started"

can any1 tell me how can i change the record source property of a report plz

thank you in advance  

____________________________
Seem Haroun

Hi,
Put your code in the Report_Open Event. That will work.


____________________________
multi-tasking - the ability to hang more than one app. at the same time.