Report.RecordSource (Access)

You can use the RecordSource property to specify the source of the data for a report.

The RecordSource property setting can be a table name, a query name, or an SQL statement. For example, you can use the following settings.

Forms!frmCustomers.RecordSource = "Customers"