Microsoft KB Archive/209095

= HOW TO: Select Controls on Subform with SetFocus Method in Access 2000 =

Article ID: 209095

Article Last Modified on 12/12/2002

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q209095



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

For a Microsoft Access 2002 version of this article, see 294212.

IN THIS TASK
SUMMARY
 * How to Select a Control on a Subform from a Main Form
 * How to Select a Control on a Nested Subform from a Main Form
 * How to Select a Control on a Main Form from a Subform
 * How to Select a Control on a Subform from a Nested Subform

REFERENCES



SUMMARY
You can use the SetFocus method for forms and form controls in Microsoft Access to select a field or control on an open form, form datasheet, table datasheet, or query dynaset, or to select other forms.

This article describes how to use the SetFocus method to select controls on subforms and nested subforms, and how to select controls on a main form from a control on a subform.

back to the top

How to Select a Control on a Subform from a Main Form
To select a control on a subform from a main form, do the following:
 * 1) Select the subform control.
 * 2) Select the appropriate control on the subform.

The following example demonstrates how to select a control on a subform from a main form:  Open the sample database Northwind.mdb or the sample Access project NorthwindCS.adp. Create a new, blank form based on the Customers table. If the field list is not visible, click Field List on the View menu. Drag the Company Name and City fields from the field list to the detail section of the form. Drag the Orders form from the Database window onto the detail section of the new form. Microsoft Access will embed the Orders form as a subform, linking the Orders form to the new form on the CustomerID field. Note that the Orders form contains its own subform to show order details.  Add a command button to the form with the following properties:

Name: GotoFreight

Caption: Freight

OnClick: [Event Procedure]

Create the following code for the OnClick property's event procedure: ' Select the Orders subform control. Me![Orders].SetFocus

' Select the Freight control on the Orders subform. Me![Orders].Form![Freight].SetFocus  Save the new form as My Customer Orders. View the form in Form view, and then click the Freight button.</li></ol>

back to the top

How to Select a Control on a Nested Subform from a Main Form
To select a control on a nested subform (a subform of a subform), do the following:
 * 1) Select the subform control.
 * 2) Select the nested subform control.
 * 3) Select the appropriate control on the nested subform.

The following example demonstrates how to select a control on a nested subform from a main form: <ol>  Continuing the example above, add the following command button to the My Customer Orders form:

Name: GotoQuantity

Caption: Quantity

OnClick: [Event Procedure]

Create the following code for the OnClick property's event procedure: ' Select the Orders subform control. Me![Orders].SetFocus

' Select the nested Orders Subform subform control. Me![Orders].Form![Orders Subform].SetFocus

' Select the Quantity field on the nested subform. Me![Orders].Form![Orders Subform].Form![Quantity].SetFocus </li> View the form in Form view, and then click the Quantity button.</li></ol>

back to the top

How to Select a Control on a Main Form from a Subform
To select a control on a main form from a subform, do the following:
 * 1) Select the main form.
 * 2) Select the appropriate control on the main form.

The following example demonstrates how to select a control on a main form from a subform: <ol>  Continuing the example above, open the Orders form in Design view. Add the following new command button to the form:

Name: GotoCity

Caption: City

OnClick: [Event Procedure]

Create the following code for the OnClick property's event procedure: ' Select the main form. Forms![My Customer Orders].SetFocus

' Select the City control on the main form. Forms![My Customer Orders]![City].SetFocus </li> Save and then close the Orders form.</li> Open the My Customer Orders form in Form view.</li> Click the City button on the Orders subform.</li></ol>

back to the top

How to Select a Control on a Subform from a Nested Subform
To select a control on a subform from a nested subform, do the following:
 * 1) Select the main form.
 * 2) Select the subform control.
 * 3) Select the appropriate control on the subform.

The following example demonstrates how to select a control on a subform from a nested subform: <ol> Continuing the example above, open the Orders Subform form in Design view.</li>  Modify the Discount field's OnExit property to be:

OnExit: [Event Procedure]

Create the following code for the OnExit property's event procedure: ' Select the main form. Forms![My Customer Orders].SetFocus

' Select the Orders subform control. Forms![My Customer Orders]![Orders].SetFocus

' Select the Freight control on the Orders subform. Forms![My Customer Orders]![Orders].Form![Freight].SetFocus </li> Save and close the Orders Subform form.</li> Open the My Customer Orders form in Form view. Use the pointer to select the Discount field in the nested Orders Subform subform. Press TAB to exit the Discount field.</li></ol>

back to the top

<div class="references_section">