|Access Developer Reference|
expression.OpenQuery(QueryName, View, DataMode)
expression A variable that represents a DoCmd object.
|QueryName||Required||Variant||A string expression that's the valid name of a query in the current database. If you execute Visual Basic code containing the OpenQuery method in a library database, Microsoft Access looks for the query with this name first in the library database, then in the current database.|
|View||Optional||AcView||A AcView constant that specifies the view in which the query will open. The default value is acViewNormal.|
|DataMode||Optional||AcOpenDataMode||A AcOpenDataMode constant that specifies the data entry mode for the query. The default value is acEdit.|
You can use the OpenQuery method to open a select or crosstab query in Datasheet view, Design view, or Print Preview. This action runs an action query. You can also select a data entry mode for the query.
|This method is only available in the Microsoft Access database environment. See the OpenView or OpenStoredProcedure methods if using the Microsoft Access Project environment (.adp).|
The following example opens Sales Totals Query in Datasheet view and enables the user to view but not to edit or add records:
|Visual Basic for Applications|