Fields are in tables and controls are on forms. If you have a control on a form that is bound to a field in a table then you can set the focus to the control with:
Me.ControlName.SetFocus
...using your ControlName of course. Where you put that command it your call. You could start by putting it in the OnLoad event of the form to watch it work.