Disable auto editing records and use "save" button instead

[Jay Pee]

Hi all,

To add/manage customers in my database I have made a (main) form with 5 sub forms in it. What I would like to do is to make a "save" button on the main form. Whatever is added (new) or edited (existing) in the main form AND/OR in the subform(s) should only be written to the actual tables after the button on the main form is pressed. If users add or edit fields and close the form without saving, nothing should change the actual data.

I've been Googling for a while now and so far I've only come up with a code to bind to an event like loosing focus. This code gives me an annoying pop-up with a YES and NO button, but even worse is I have to use to code for the main form and every individual sub form. When I only use the code for the main form to get the pop-up only once, users can still mess around with the fields of the sub forms without having to press a button to confirm their additions or changes.

How would I create such a button which affects both the main form and all 5 five sub forms?



Thanks!

[RuralGuy]

You may want to look into Transactions: http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

[June7]

Only option I know is unbound forms and code (a lot of code) that writes data to record only when appropriate.

A primary purpose of form/subform arrangement is to eliminate need for code to write records.

EDIT: I see RG got a post in first. I have used Transaction but not when several subforms are involved. No idea how that would work.

[Jay Pee]

OK so I get that Access is inherently designed to do pretty much exactly the opposite of what I need..

I'll go and take a look at transactions.

[Jay Pee]

It is seems it is almost impossible for me to make this, given my limited knowledge.

An alternative would be a 'cancel changes' button which cancels all additions/changes to the fields of the selected record in the main form AND in the several sub forms as well. Would this be possible: one button to cancel everything? Note: under no circumstances must that button be allowed to delete data already available prior to opening the form incl its sub forms.