SetFocus Statement

[Templer]

Hi everyone,

Can anyone tell me what is wrong with this piece of code?

Private Sub HeaderAcc_Enter()
On Error GoTo Err_HeaderAcc_Enter

Address1.SetFocus

Exit_HeaderAcc_Enter:
Exit Sub

Err_HeaderAcc_Enter:
MsgBox Err.Description
Resume Exit_HeaderAcc_Enter

End Sub

When I tab to the field HeaderAcc the SetFocus statement is immediately actioned, why doesn't it wait for me to press enter?

 

[EndersG]

The GotFocus event is triggered the second it receives the focus, as it is supposed to

 

[dgm]

You want something like this:

Private Sub HeaderAcc_KeyDown(KeyCode As Integer, Shift As Integer)
    ' Get return key
    If KeyCode = 13 Then
        Address1.SetFocus
    End If
End Sub

Although you should be able to change the tab order to do this, unless your doing something out of the ordinary.

Dave