Autosave

R

Rick B

By design, Access wil save records when you move to the next record. There
is no "setting" for this.

You could build code to capture this and ask if the user would like to save.
You could build "save" buttons. But I'm not sure why you would want to.
Anyone who is familiar with Access would probably have a lot of trouble
using your database if you start monkeying with standard features like how a
record is saved.

Rick B
 
A

Arvin Meyer

Unbind the table from the forms and write the record to the table in code.
Of course that means a lot more work and it also means that you can't take
advantage of many of Access's properties (.OldValue, etc.)

It's probably easier to use bound forms and delete the few records you don't
want.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
L

Lynn Trapp

I thought that was what you meant, but wanted to be sure. You can't stop
that process but you can control it. You can follow Arvin's approach of
using an unbound form but, as he said, that takes quite a bit of work. You
can also, use the BeforeUpdate event of the form to control, to some extent,
when a user saves a record.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
 
Top