Set the Cycle property of the subform to "All Records". Type data into
the first field, press <Tab>, type data in the next field, press
<Tab>, up to the last field - press <Tab> and you're in the first
field on the new record. No code, no clicks, no hassle.