No save prompt after Yes/No (check box)

[Bradex]

I was surprised to find that access auto-saves changes to the Yes/No (checkbox) control without prompting me to save the changes.

I find it highly inappropriate as a random left-click on the form by mistake can easily change the checkbox data and it also get saved!

[June7]

The checkbox is just another data entry control. No data entry control has any built-in prompting to challenge the user if they really want to make this change. You can program this behavior in the control's BeforeUpdate event. Or use a combobox for the yes/no field input. I've used a combobox.

[Bob Fitz]

You could put some code in the Before Update event of the checkbox control. Something like:

    If MsgBox("Update Record?", vbYesNo, "Confirmation Required") = vbNo Then        Cancel = True
    End If

[Bradex]

I am an amateur user, and just learnt that Access autosaves all entries/edits in the form.

Since I wanted it to prompt me for saving before closing or moving on to a new record, I used the following code (learnt from elsewhere, full credits to the original code author):

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 Record ???") = vbNo Then
  Me.Undo
 End If
End If
End Sub