Closing the form without saving the information

[selvakumar.arc]

I am trying to close the form without saving form input, following are the code snippet. But it is not working means that the form input are saving in database even if the user click the exit button. I dont know what is the issue here...
Private Sub cmdExit_Click()
DoCmd.Close acForm, Me.Name, acSaveNo
End Sub

Regards,
Selvakumar R

[ssanfu]

DoCmd.Close acForm, Me.Name, acSaveNo

The "acSaveNo" parameter doesn't affect the data, it is if you have made changes to the form (using code). For example, if you have code to add an unbound text box and you didn't want to save the change, then you would use "acSaveNo".

Data is automatically saved if you change records or close the form. There are a couple of other ways the data is saved - on a requery (I think).


I have used the "Me.Undo" command in button click events.... with varying amounts of success.

[selvakumar.arc]

Yes, I added "Me.Undo" before closing the form and it is working. Thanks for your support.

[Dal Jeanis]

ssanfu - Should he check "If Me.Dirty" before executing the Me.Undo? I can't recall one way or the other, but I'm wondering if there might be a gotcha where something that had been officially "saved" might get undone.

[ssanfu]

@Dal - Good point. I don't recall what code I ended up with. Hence the "with varying amounts of success".

When I find time I will have to experiment .... err I mean do some testing.....

[Dal Jeanis]

You should Experiment... FOR SCIENCE! Mwaaahhaaahhaaa!