Move cursor in Form to a specific field on click of button

[gg091869]

I have a Form with a field named "PickTicket" when I enter data in the required field(s) and click on a button to add a new record I want the cursor to return to the field "PickTicket" so that the user doesn't have to click on the field to begin a new record.

Table name is LookUpPickTicket and field name is PickTicket

[trevor40]

Hi,
Try me.gotocontrol.PickTicket
OR
set the tab order for your fields with "PickTicket" = 1

[June7]

I use: Me.controlname.SetFocus