DoCmd.SelectObject method (Access)

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

Syntax

expression.SelectObject (ObjectType, ObjectName, InNavigationPane)

expression A variable that represents a DoCmd object.

Parameters

Name Required/Optional Data type Description
ObjectType Required AcObjectType An AcObjectType constant that specifies the type of object that 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.

Remarks

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.

Example

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

DoCmd.SelectObject acForm, "Customers", True

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.