Bound form auto saving data

[Paul]

Hello,

I am having an issue where my form, bound to a DAO recordset, keeps
automatically updating any changes that I make to the data to the database
when I close the form. I have the form's Allow Edits = True and Allow
Deletions = True. I evaluate these properties so I can set the form's other
properties such as its caption and etc. So, my question is that will a bound
form automatically make any updates without the user clicking an 'Update'
command button? I am using Access 2003.

Any help would be appreciated.

Regards,

 

[Paul]

Oh, I see. Thanks for the information Rick. I'm going to give the user a
command button to 'Save and Close' the form. This waythey will think they are
actually saving the data even though we both know what is really happening
behind the scenes. Thanks again.

 

[Rick Brandt]

Oh, I see. Thanks for the information Rick. I'm going to give the
user a command button to 'Save and Close' the form. This waythey will
think they are actually saving the data even though we both know what
is really happening behind the scenes. Thanks again.

Not a good idea in my opinion. That will only create the idea that if they move
to a different record or close the form WITHOUT pressing save that the data is
in fact not saved. Just explain to your users how Access works.

 

[HL]

It may sound stupid but I really want to know if there is anyway to disable
the autosave function so that records won't be edited+saved by mistake.
Thanks for any answer : )

 

[Rick Brandt]

It may sound stupid but I really want to know if there is anyway to disable
the autosave function so that records won't be edited+saved by mistake.
Thanks for any answer : )

Issue an Undo and set Cancel = True in the BeforeUpdate event.

(Better idea)
Lock the form and provide an {Edit} button that unlocks it. Then "accidental"
changes are not a concern.