confirm changes (1 Viewer)

[msp]

I have a form currently if someone moves off the form it automatically saves changes what I sould like to do is if someone makes a change on a form the tries to move a message box appears asking them to confirm changes or not...

 

[Rich]

Here's a simple example
http://www.access-programmers.co.uk/forums/showthread.php?t=72380

 

[maxmangion]

you can do that by placing some code in the beforeupdate event, but if you use this form for data inputting, you will get sick of it getting a confirm msg each and every time.

you can do something like the following on the before update event:

if msgbox ("Confirm Changes", vbyesno, "Warning ...") = vbyes then
DoCmd.RunCommand acCmdSaveRecord
else
Me.Undo
End If

 

[msp]

Thanks Rich et al - this is perfect