With the form's Cycle Property set to the default setting of "All Records" tabbing out of the last control will take you to a new record automatically.
If you have fields that are required, i.e. have to be filled in to make a complete record, you'll need to place validation code in the Form_BeforeUpdate event to insure that they are filled in.
Linq ;0)>