Tab Postion when adding a record

  • Thread starter Thread starter Bob
  • Start date Start date
B

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?
 
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?
Click to expand...

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.
 
Back
Top