BrowseTo macro action
Applies to: Access 2013, Office 2013
You can use the BrowseTo action to navigate between objects in place. You can also change the source object of a subform control by specifying the Path to Subform Control argument. Use BrowseTo to navigate from form1 to form2 without opening up a new window.
Setting
The BrowseTo action has the following argument.
Action argument |
Description |
---|---|
Object Type |
The object type to which to browse. |
Object Name |
The object that loads inside the subform control referenced by the Path to Subform Control argument. |
Path to Subform Control |
If specified, the path from the main form of the application to the target subform control that loads the object specified by the Object Name argument. |
Where Condition |
If specified, replaces the Where condition of the object record source. |
Page |
If specified, sets the page of the continuous form that will be made the current page. This argument is web only. |
Data Mode |
If specified, the data entry mode of the form. |
Remarks
The PathToSubFormControl argument must be specified using the syntax in the following code 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 Path to Sub Form Control 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 Object Name 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 example shows how to use the BrowseTo action to open a report in a subform control or within a navigation control.
Sample code provided by the Microsoft Access 2010 Programmer’s Reference.
OnError
Go to Next
Macro Name
/* Try to load the report in the host form (frmAuthorsParameter) */
BrowseTo
Object Type Report
Object Name rptChapters
Path to Subform Control frmAuthorsParameter.sfrmChild
Where Condition
Page
Data Mode Edit
Parameters
SelectedAuthor =[cboAuthor]
/* if this fails, try to load it in the navigation subform */
BrowseTo
Object Type Report
Object Name rptChapters
Path to Subform Control frmMain.NavigationSubform>frmAuthorsParameter.sfrmChild
Where Condition
Page
Data Mode Edit
Parameters
SelectedAuthor =[cboAuthor]