CODEWITHSUNDEEP
vbams-accessms-access-2010
Jose Partida
Jose Partida

Reputation: 23

Close a MS Access form without any dirty data saving

New user to MS Access here. I'm creating a form for insertion into my database (simple user info database : address name phone etc). However I've realized that anytime a user writes ANYTHING on the form, access saves it, even if it's a single letter. I have a save button on my form and I was wondering is there a way to have the form only save when the user clicks save? I'm completely new to access so any specific examples / explanations would be greatly appreciated(ex if I would have to put in vba lines how would I go about that).

Upvotes: 0

Views: 323

Answers (1)

Gustav
Gustav

Reputation: 56026

That's the default behaviour of an Access form.

If you don't want that, set Cancel = True in the BeforeUpdate event of the form.

Upvotes: 1

Related Questions