Microsoft KB Archive/208178

= ACC2000: GoToControl to Control with Focus in AfterUpdate Ignored =

Article ID: 208178

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q208178



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

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



SYMPTOMS
You you try to use the GoToControl method or the SetFocus method in the AfterUpdate event of a control to set focus back the control that is being updated, the GoToControl or SetFocus method will be ignored. For example, the following code, will not cause the control named MyControl to retain focus once it is updated: Private Sub MyControl_AfterUpdate DoCmd.GoToControl "MyControl" End Sub You will see the same behavior when you use the GoToControl action in a Macro.



CAUSE
You cannot set the focus on a form to an object that already has focus.



RESOLUTION
You can get the desired results in one of the following ways:
 * To stop the control focus from changing, regardless of the update status of the control, set Cancel = True in the Exit event of the control.
 * If you want to prevent the changed data from being saved, set Cancel = True in the BeforeUpdate event of the control.

The following example maintains focus on a control, regardless of the update status of that control: Private Sub MyControl_OnExit(Cancel As Integer)

Cancel = True

End Sub When you add this code to a control, the only way to move to a different control on the form is by using the pointer.



Steps to Reproduce Behavior
  In the sample database Northwind.mdb, create the following macro named Test1:   Macro Name   Condition         Action --  Test1        ([City]="aaaa")   GoToControl   Test1 Actions -  GoToControl Control Name: [City]  Open the Customers form in Design view. Set the City control's AfterUpdate property to the Test1 macro. View the Customers form in Form view. Type aaaa in the City field and press TAB. Note that the focus moves to the next field in the tab order. However, if you had moved to another control before pressing TAB, the focus would not have changed.</li></ol>

<div class="references_section">