O

OpenQuery Action

You can use the OpenQuery action to open a Select query or Crosstab query in Datasheet view, Design view, or Print Preview. This action runs an Action query. To specify parameters for an Action query, you use the RunSQL action. You can also select a data entry mode for the query.

The OpenQuery action is similar to clicking the Open button or Design button after clicking Queries under Objects in the Database window, and then selecting a query. With this action you can select additional options.

If you use Datasheet for the View argument, Access displays the result set if it is a Select query, Crosstab query, Union query, or Pass-Through query whose ReturnsRecords property is set to Yes; and it runs the query if it is an Action query, Data-Definition query, or pass-through query whose ReturnsRecords property is set to No.

The OpenQuery action has the following arguments.

Action argument	Description
Query Name	The name of the query to open. The Query Name box in the Action Arguments section of the Macro window shows all queries in the current database. This is a required argument. If you run a macro containing the OpenQuery action in a library database, Access looks for the query with this name first in the library database, then in the current database.
View	The view in which the query will open. Click Datasheet, Design, Print Preview, PivotTable, or PivotChart in the View box. The default is Datasheet.
Data Mode	The data entry mode for the query. This applies only to queries opened in Datasheet view. Click Add (the user can add new records but can't edit existing records), Edit (the user can edit existing records and add new records), or Read Only (the user can only view records). The default is Edit.