Solved Autosave Continuous Form

[Razon09]

Hi, I tried to make a continuous form. I made a cancel button to close the form and to undo every change that has been made. It works for my single form with this:

Private Sub CMD_BACKTOMAIN_Click()
Me.Undo
DoCmd.Close acForm, "FRM_PURCHASING ORDER", acSaveNo
DoCmd.OpenForm "MAIN FORM"
End Sub

But when I use it for a continuous form, It's not working.

Can anyone help?

 

[arnelgp]

try to google using Transactions in Ms Access.

 

[Gasman]

Seems to be a rash of people recently who want to work the complete opposite way that Access works?, here and on other sites.
When I first started with Access, that was one of the hardest things I had to get used to.

 

[ebs17]

DoCmd.Close acForm, "FRM_PURCHASING ORDER", acSaveNo
' better
DoCmd.Close acForm, Me.Name

acSaveNo has no relevance here, it doesn't affect data, just a change to the form design (which you don't make).

A continuous form is mandatory a bound form, interacting accurately and only with the current record. This gives you the same behavior as in a bound single form.