Export (0) Print
Expand All
Expand Minimize

DoCmd.SelectObject Method (Access)

The SelectObject method carries out the SelectObject action in Visual Basic.

expression .SelectObject(ObjectType, ObjectName, InNavigationPane)

expression A variable that represents a DoCmd object.

Parameters

Name

Required/Optional

Data Type

Description

ObjectType

Required

AcObjectType

A AcObjectType constant that specifies the type of object you want to select.

ObjectName

Optional

Variant

A string expression that's the valid name of an object of the type selected by the objecttype argument. This is a required argument, unless you specify True (–1) for the InNavigationPane argument.

InNavigationPane

Optional

Variant

Use True to select the object in the Database window. Use False (0) to select an object that's already open. If you leave this argument blank, the default (False) is assumed.

You can use the SelectObject method to select a specified database object.

The SelectObject action works with any Access object that can receive the focus. This action gives the specified object the focus and shows the object if it's hidden.

The following example selects the form Customers in the Database window:

DoCmd.SelectObject acForm, "Customers", True
Show:
© 2014 Microsoft