this should be quick and easy...

I'm actually programming in Access 97 but i'm sure there's some easy VB Code that will help me...

I have a Msg Box pop up if the user tries to leave the record or close the form. It asks them if they need to go back and enter some information in a particular field. If they hit "Yes" i want Access to cancel the event they just activated (going to another record or closing the form). What can i do?

TIA!!!!
Ted

VB Code:

Private Sub Command1_Click()
If MsgBox("About to cancel this operation.  Any changes will *NOT* be saved. Are you sure?", vbYesNo, "Verify Cancel Changes") = vbNo Then
   'do whatever you were about to do
Else
   'they clicked yes
   Exit Sub
End If
End Sub