0 out of 1 rated this helpful - Rate this topic

DoCmd.SelectObject Method

Office 2007
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

NameRequired/OptionalData TypeDescription
ObjectTypeRequiredAcObjectTypeA AcObjectType constant that specifies the type of object you want to select.
ObjectNameOptionalVariantA 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.
InNavigationPaneOptionalVariantUse 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


Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.