DoCmd.OpenTable Method (Access)
The OpenTable method carries out the OpenTable action in Visual Basic.
Syntax
expression .OpenTable(TableName, View, DataMode)
expression A variable that represents a DoCmd object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
TableName |
Required |
Variant |
A string expression that's the valid name of a table in the current database. If you execute Visual Basic code containing the OpenTable method in a library database, Microsoft Access looks for the table 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 table will open. The default value is acViewNormal. |
DataMode |
Optional |
AcOpenDataMode |
A AcOpenDataMode constant that specifies the data entry mode for the table. The default value is acEdit. |
Remarks
You can use the OpenTable method to open a table in Datasheet view, Design view, or Print Preview. You can also select a data entry mode for the table.
Example
The following example opens the Employees table in Print Preview:
DoCmd.OpenTable "Employees", acViewPreview