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