Special Edition Using Access 97, Second Edition

Using SQL Statements in Forms, Reports, and Macros

If you create a large number of forms and reports based on queries or that use queries, or if you use macros to run Select and Action queries, the query list in your Database window can become cluttered. You can use SQL queries you write or copy from the SQL dialog in place of the names of query objects and then delete the query from your database. You can use SQL statements for the following purposes:

• Record Source property of forms and reports. Substitute the SQL query text for the name of the query in the Record Source text box.

• Row Source property in lists and drop-down combo lists on a form. Using an SQL statement rather than a query object gives you greater control over the sequence of ...