How do I get a Close event never to prompt to save?
Basically, I have a procedure that modifies a form in design view before opening it. When the user closes it (with X button or CTRL+F4), it always prompts to save changes.
I would make a Close button (docmd.Close (acSaveNo)), but the form is in Datasheet view. Even if I had a button, the user could always use CTRL+F4, which I believe directly triggers the close event.
How can I get around this?
Basically, I just do not want a user to save these changes or even be bothered to do so!