Prevent Tab from creating new record

I am working on a form with several tab stops.  At the end of the form if the user isn't careful pressing tab saves the current record and starts a new record.  Is there any way to prevent Tab from creating a new record.
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
You can set the Form's Cycle property to "Current Record", which will keep the user on the same record.

Open the form in Design view and select the Other tab in the Properties dialog, and you'll see the Cycle property.
Access forms are designed to save records.  Any time you move the focus to a new record or close the form, etc.  Access will save the current record.

Changing the Cycle property to Current Record as Scott suggested will keep the user from inadvertently tabbing to a new record but if you are trying to get control of the save process, use the FORM's BeforeUpdate event.  That is the last event that fires before a record is actually saved and you can't avoid it so it is the perfect event to use for final validation and to cancel the save if that is your intention.
MwvarnerAuthor Commented:
Thanks,  That is what I needed.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.