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...
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:
Code:
if msgbox ("Confirm Changes", vbyesno, "Warning ...") = vbyes then
DoCmd.RunCommand acCmdSaveRecord
else
Me.Undo
End If