Do not save record with tab all the way through

[B30]

I am new to Access (and databases) and my terminology is slack. I am creating a form and I have a "Save Record" button at the end of the form for the info to update the table. Currently, if I tab all the way through the form and tab past the "Save" button, it will save the record. I want to change it so that the button has to be clicked to update the table, and not allow the tab button to update it. Thanks for the help.

[ranman256]

Sorry, in access, moving off a record is an automatic save. (be it arrow, or tab, etc) Its a passive action.
The button idea is just a formality for users to think they did something.

[B30]

Thanks for the help anyway.

[Missinglinq]

...The button idea is just a formality for users to think they did something...

That really sums it up well! What you can do, to prevent 'accidental' saving, is to check with the user to see whether or not they want to save the new or edited Record:

Private Sub Form_BeforeUpdate(Cancel As Integer)

If Not (Me.NewRecord) Then
  If MsgBox("Would You Like To Save The Changes To This Record?", vbQuestion + vbYesNo + vbDefaultButton1, "Save Changes to Record ???") = vbNo Then
   Me.Undo
  End If
Else
  If MsgBox("Would You Like To Save This New Record?", vbQuestion + vbYesNo + vbDefaultButton1, "Save This New Record ???") = vbNo Then
   Me.Undo
  End If
End If

End Sub

If they select 'No' from the Messagebox the New Record or changes to the Existing Record will be dumped.

Linq ;0)>