Start at 1st Field When creating a New Reord Problem

[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.

 

[Arvin Meyer [MVP]]

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.

 

[nytwodees]

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.

 

[Arvin Meyer [MVP]]

Use the Current event of the form to move the cursor to the first control in
the tab order:

Private Sub Form_Current()
Me.txtFirstControlName.SetFocus
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[nytwodees]

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?

 

[Arvin Meyer [MVP]]

Not at all. It's probably happening this time because your subform is the
last control where you are entering data. Unless you tell Access that you
want to start at the first control, it assumes that you want to stay where
you are. You may also need to adjust the enter key behavior and the cycle
property of the form.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[nytwodees]

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