How to disable autosave in a data access page

[mtahola]

hi!

I'm working on a data access page which saves data into a SQL table.

Access 2000 help says that "You don't need to save new data in records. Access automatically saves a record when you do any of the following: move the focus to a different record; close the active form, datasheet, data access page, or database; or quit Access."

I don't want this autosave option to be enabled, i.e. users would have to explicitly push the save button to save the made changes.

So, my question is that is it possible to disable automatic saving?

br, M

 

[jeremie_ingram]

Why not just insert text fields into the form, and then code the button to take thefrom the fields to the tbl? In other words, do not link the fields on the form to the fields in the tbl, just use them for data entry and your code would do the update.

 

[mtahola]

If I don't link the fields, how am I able to search and update previously inserted data... or did I misunderstood you?

For new records your suggestion is good, I think.

M

 

[Pat Hartman]

Using bound forms implies that you want Access to retrieve and update records for you. You can't just turn off the updating part. If you don't want a record to be automatically updated, you'll need to switch to unbound forms. I am not familiar with DAP so I don't know what events are available. With a regular form, you could put code in the BeforeUpdate event to stop the automatic update but you're making a lot of work for yourself to no benefit.

 

[thinknirmal]

Undo action

For every event, you can set the action 'Undo' to be executed. If you are in a form, this will reset your fields before moving to another field or before you close the form.