The data source is defined by the ConnectionString, RecordSource, and Filter properties. These regular report properties are set in the Property Window by clicking on the background area where there are no sections. The data source is defined when you use the New Report Wizard to create the report.
To change the data source for a report
View the report in Design mode .
Click the DataSource
icon .
The Data Source tab of the New Report dialog box appears.
Specify the ConnectionString and RecordSource properties, then click OK.