Access 2002 Programming by Example

Working with the Record Source Property

You could also set the record source to an SQL query through this property. This gives you the ability to use variables to change table names. This makes the query a dynamic record source for the report.

There is another benefit from using a dynamic record source, and this applies to either a form or a report. If you are working with huge databases, involving hundreds of thousands of records, you can avoid the slower performance associated with opening a form or report tied to a single huge table. Break the table into smaller tables and access the tables dynamically. That way the user accesses one group of records at a time.