report record source

[wlc04]

I would like to be able to set the record source of a report programatically , but I am not having much luck. I have 2 queries which could be the source depending on other parameters in the program, so depending on these parameters I want to change the record source.

Any ideas?

[PEB]

Hi,

You have to set the property RecordSource of your report like this:

Reports!Report1 .RecordSource = "Table1"

On your On Open event you can tape

Reports![My_report].RecordSource = "MyreportSQ L"