How do i stop acces from updating the database on a new query

[Hitower]

Ok i am guessing that this will be a simple one for u all but i dont know so i am just gonna ask neway .
When u do a query in a database and u change something in the form and u leave the form it automaticly saves the changes u have made. How can i interrupt that by means of like a msgbox promping to cancel it ? I want VB to ask if i want to keep the changes or not but i need the code to stop acces from updating the db when i press cancel
btw yes i am a newbie in this so dont laugh ok

Regards Hitower

 

[KarMac21]

Try this HiTower:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.Dirty Then
If MsgBox("Update Records?", vbQuestion + vbYesNo, "Update Confirmation&quot = vbNo Then Cancel = True
End If
End Sub

I think this should work for you.
Shane