Tab Postion when adding a record

[Bob]

In the form there is command button to add a new record.
When the command button is select to add a new record, the
tab or cursor remains on the add button icon. How can one
select the add new record command button and once this is
clicked to have the cursor begin in your first tab postion
and which is my first field in the form?

 

[John Vinson]

In the form there is command button to add a new record.
When the command button is select to add a new record, the
tab or cursor remains on the add button icon. How can one
select the add new record command button and once this is
clicked to have the cursor begin in your first tab postion
and which is my first field in the form?

Put a line in the VBA code in the button's Click event:

Me!controlname.SetFocus

where the controlname is the desired control's name.