Move focus to specific field

[Lars Brownie]

When the user presses the built-in form button (little triangle with
asterisk) to make a new record, I would like the focus to move a specific
field, so that the user can start entering the form in the right field. How
can I accomplish this?
Thank you, Lars

 

[Allen Browne]

1. Use the Current event of the form.
2. Test its NewRecord property.
3. SetFocus to the desired field.

Example event procedure:

Private Sub Form_Current()
If Me.NewRecord Then
Me.[NameOfSomeControlHere].SetFocus
End If
End Sub

 

[Lars Brownie]

That did it! Thanks Allen.
Lars

1. Use the Current event of the form.
2. Test its NewRecord property.
3. SetFocus to the desired field.

Example event procedure:

Private Sub Form_Current()
If Me.NewRecord Then
Me.[NameOfSomeControlHere].SetFocus
End If
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

When the user presses the built-in form button (little triangle with
asterisk) to make a new record, I would like the focus to move a specific
field, so that the user can start entering the form in the right field.
How can I accomplish this?
Thank you, Lars