I would like to be able to exit a form t out with out save it?

J

john

I would like to be able to exit a form or close it out without saving the
information that was already added in. How do I do this?
 
R

rba

Hey John

Put a command button on your form, use the wizard to create an close form
action.
After that look in the properties and go to events then choose "on click"

in the VBA code you will see a line with " DoCmd.Close"
replace it with following line
DoCmd.Close acForm,"formname",acSaveNo

this works for me

best regards
 
Top