If the button is on the form, then in the button's OnClick event
DoCmd.Close ,,acSaveNo
You can stop after the word Close, the rest keeps you from being prompted to
save changes to the form, if you made any. It will automatically discard any
changes if you use acSaveNo.