Jan 9, 2003 #1 rphbrew Technical User Nov 30, 2002 40 US I am using the following code DoCmd.CLOSE acForm, "FormName", acSaveNo I have this on a cancel request button. However the data entered gets saved.
I am using the following code DoCmd.CLOSE acForm, "FormName", acSaveNo I have this on a cancel request button. However the data entered gets saved.
Jan 9, 2003 #2 jebry Programmer Aug 6, 2001 3,006 US Hi! In the cancel button add a Me.Undo and then close. hth Jeff Bridgham bridgham@purdue.edu Upvote 0 Downvote
Jan 9, 2003 Thread starter #3 rphbrew Technical User Nov 30, 2002 40 US Worked like a charm thanks Upvote 0 Downvote