Is it possible to disable auto save of records in Access?

[Paul Barnard]

I find that when the user enters a form from the main menu, they do not
always click on Add Record, they overwrite the displayed record. Is it
possible to display a message asking the user if they want to make a change
to an 'edited' record?

 

[Jeanette Cunningham]

Hi Paul,
some people use a button which is clicked to allow edits.
The code to allow edits is Me.AllowEdits = True
To stop edits use Me.AllowEditw = False

I tend to use search forms before a user can open any form to edit. It seems
to stop people opening a form and typing away without thinking about it.

I can't imagine that anyone would open a word document and start typing over
the text that is already there without realising that they are replacing the
text they are typing over.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Wayne-I-M]

To add to what Jeanette said
here are another 2 methods
http://www.mvps.org/access/forms/frm0010.htm