Form field focus

I am opening a form with a button using following code:

Private sub dropoff_Click()
DropOffUserForm.Show
End Sub

This works fine. It opens with no focus in any fields. I want then when it opens for the focus to be in the first field. I thought if there wasn't code specifically for it, I could send keystrokes to Tab (which works to put cursor in second field), the shift+tab to bring cursor back to first field?

Hello Nathan323,

Any control on the Form that can take the "focus" will be selected when the user form is displayed. To control the order of which control will receive focus first then you need to set the Tab Order of the controls on your form. You can do this by changing the TabIndex property of the control.

You can also try to add this after DropOffUserForm.Show

With DropOffUserForm
.'ControlName'.SetFocus
end with