DoCmd.SelectObject Method

Access Developer Reference

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 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.

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 form Customers in the Database window:

Visual Basic for Applications
  DoCmd.SelectObject acForm, "Customers", True