One reason for using a SQL statement for a record source is that it is easier to transfer a form or report to another database because the record source is contained in the object.

Question

Quizplus · Accepted Answer

By using a SQL statement as the record source, the data is contained within the form or report object, making it easier to transfer to another database without having to separately link the table or query used as the record source.

One Reason for Using a SQL Statement for a Record