prevent creating records until a button is clicked

[shadowsedge]

In Access 2016, is there a way to prevent a from from creating a record until a button is pressed?As of now, when 1 character is inserted, a new record is created. I would like that to happen only if a button is pressed on the bottom footer.I know this is the default action of access 2016. Is there an option to change it?

[JoeM]

I believe that is pretty much the default behavior of Bound Forms in all versions of Access.

You could always make it an unbound form, and then have your button write the record to the table by creating SQL code from the selections and running an Append (Insert) Query to add the record.

Or you could get a little tricky and try using a Bound Form, and have some required field that is not listed on the Form, but gets filled out when the button is clicked. If you go that route, you might also need to add some error handling to handle different situations/scenarios (where they exit without clicking the button, it may give you some warnings about not being able to add the record).

[Missinglinq]

With Unbound Forms you end up writing code for virtually everything that needs to be done, basically having Access do nothing; not an easy task for a programming newbie!

I'd simply confirm, before the Record is actually saved, that the user wants to save it. Code to do this would be something like this:

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

Linq ;0)>