set focus cursor again for first textbox after press Enter last textbox

[Mussa]

I have textboxes (textbox71:textbox142). so what I want after filling number into textbox 142 and press enter should return cursor into textbox71 to show format number into textbox142.
I used this but doesn't work !

Private Sub TextBox142_AfterUpdate()
TextBox71.SetFocus
End Sub

any idea guys?

 

[Legacy 143009]

Something like this:

Private Sub TextBox142_KeyDown(KeyCode As Integer, Shift As Integer)
    If KeyCode = 13 Then
         TextBox71.SetFocus
    End If
End Sub

 

[Mussa]

thanks .

it shows error

I'm sure about names and numbers for textboxes .

 

[Legacy 143009]

I think you have another keydown event at somewhere else. Just move the If condition there.

 

[Mussa]

I no know what happens !
I did not find duplicated for this event , but now it works !
thanks very much for your help

 

[Legacy 143009]

No problem Thanks for the feedback