Microsoft Access VBA Programming for the Absolute Beginner

Opens a view in an Access Data Project.

Syntax

DoCmd.OpenView ViewName[, View][, DataMode]

with the following parameters:

ViewName

A string indicating the name of the view in the current database to open.

View

An AcView constant indicating in which view the ADP view will open. Possible values are acViewDesign (design view), acViewNormal (datasheet view, the default), and acViewPreview (print preview).

DataMode

An AcOpenDataMode constant defining the data entry mode for views opened in acNormal view. Possible values are acAdd, acEdit (the default), and acReadOnly.

Comments

The OpenView method was first introduced in Access 2000.