cancel updating/adding record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which opens in add mode. I have a cancel button on a form
which when clicked, I want to close the form and cancel any updates and NOT
save the new record and anything entered.
I've set the on click property to docmd.close,,acSaveno.
This works fine when a text box is updated--the record is not saved. There
is also a combo box. When a selection is made in the combo box, the record
is saved even though it's set to don't save. Why is this the case for a
combo box, and how can I get around it?
 
the acSaveNo has no effect on the record: it only determines whether design
changes for the form are saved.

Instead, undo the record to cancel it:
If Me.Dirty Then
Me.Undo
End If
DoCmd.Close acForm, Me.Name
 
Back
Top