Dawn- Also, the acSaveYes parameter of the Close method saves only any *design* changes to the form. It doesn't save the data. But of course, closing the form will attempt to save the data.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Crosier, Dawn Sent: Tuesday, January 17, 2006 4:52 PM To: [email protected] Subject: RE: [ms_access] Use Form to Generate Report What I ended up doing was: If Me.Dirty Then DoCmd.Close acForm, "frmRecipesToPrepare", acSaveYes Your method is much better! Thanks. Dawn Crosier Application Specialist "Education Lasts a Lifetime" -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Tuesday, January 17, 2006 4:32 PM To: [email protected] Subject: RE: [ms_access] Use Form to Generate Report .. Me.Dirty = False John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
