save operation

[angie]

i make changes in forms and queries and when i close an object access
automatically saves the changes. how can i get a confirmation message first?

thank you in advance!

 

[Douglas J. Steele]

Are you making design changes to the forms and queries, or are you using the
forms and queries to change underlying data in the tables?

If the latter, that's how Access is designed. As soon as a changed row loses
focus, the data is saved. In a form, you could put logic in the form's
BeforeUpdate event to give a confirmation message (and you can prevent the
change from being saved by setting the Cancel parameter to True). This will
be on a row-by-row basis. There's nothing you can do to get a confirmation
message if you're working directly with a Select query (but then you
shouldn't be: you should use a form)