Start at 1st Field When creating a New Reord Problem

  • Thread starter Thread starter nytwodees
  • Start date Start date
N

nytwodees

I have a form that also has a sub-form within it. Whenever I click on the
asterisk on the record Navigator Bar to create a new record, the cursor goes
to the 1st field in the sub-form instead of going to to the 1st field in the
main form. How can I correct this?

I am using Access 2007.
 
In the form's Design View set the tab order either from the dialog box or on
the property sheet by manually typing it in.
 
On the form, in design view, I only know how to arrange the order using the
"Tab Order" selection from the form window. The tab order seems OK - it
works properly, the problem occurs when going to a New record.
 
Thank you Arvin -that code worked. I don't remember having this problem
before when using a sub-form within a form. Is this unusual?
 
Hi Arvin:

Thanks for your reply.

On the subform I also had to insert that same code "On Current" to assure
the cursor would go to the 1st field in the subform (after leaving the Main
Form section).

Dan
 
Back
Top