Bound form auto saving data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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,
Click to expand...

Yep. That is how Access works. As soon as you leave a record that has been
edited whether by moving to a different record or by closing the form the
changed record is saved to disk.
 
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.
 
Paul said:
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.
Click to expand...

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.
 
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 : )
 
HL said:
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 : )
Click to expand...

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.
 
Back
Top