Access

[Derek]

I have a bit of an issue. I am using Access 2003, I have a form that
contains a subform. This subform will only hold 1 piece of information for
each record, so here is my issue.

I have set the tab order on the form, and that works fine, however, when I
am in the last box on the subform, which is in table view, instead of
changing the main form to the next record, it just addes another row to the
subform. Is there a way to stop that?

Secondly, how do I make it so that when the form changes records, the focus
is back on the first entry box rather than elsewhere on the form?

Thanks.