Table of contents
TOC
Collapse the table of content
Expand the table of content

DoCmd.BrowseTo Method (Access)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

The BrowseTo method performs the BrowseTo action in Visual Basic.

Syntax

expression. BrowseTo( ** ObjectType, ** ObjectName, ** PathtoSubformControl, ** WhereCondition, ** Page, ** DataMode )

expression A variable that represents a DoCmd object.

Parameters

NameRequired/OptionalData TypeDescription
ObjectTypeRequiredAcBrowseToObjectTypeThe object type to which to browse.
ObjectNameRequiredVariantThe object that loads inside the subform control referenced by the PathtoSubformControl argument.
PathtoSubformControlOptionalVariantIf specified, the path from the main form of the application to the target subform control that loads the object specified by the ObjectName argument.
WhereConditionOptionalVariantIf specified, replaces the Where condition of the object record source.
PageOptionalVariantIf specified, sets the page of the continuous form that will be made the current page. This argument is Web only.
DataModeOptionalAcFormOpenDataModeIf specified, the data entry mode of the form.

Remarks

Use the BrowseTo method to navigate between objects in place. You can also change the source object of a subform control by specifying the PathToSubFormControl argument. You can use BrowseTo to navigate from form1 to form2 without opening up a new window.

The PathToSubFormControl argument must be specified using the syntax in the following example:

Main Form.SubForm Ctrl 1>Form 2.SubForm Ctrl 2>Form 3.SubFormCtrl3

In this example, the Main Form is the top level form in the Access client application. The PathToSubFormControl argument must alternately specify form and subform control names leading from the main form to the subform control that is the container of the object specified by the ObjectName argument. Each subform control specified must be a control on the form that precedes it. The path must end with a subform control.

Example

The following code example opens the "EventDS" form in place in edit mode in the "NavigationSubform" subform control of the "Main" form.

DoCmd.BrowseTo ObjectType:=acBrowseToForm, _ 
ObjectName:="EventDS", _ 
PathToSubformControl:="Main.NavigationSubform", _ 
WhereCondition:="", _ 
Page:="", _ 
DataMode:=acFormEdit

See also

Concepts

DoCmd Object

© 2018 Microsoft