I didn't know that worked either. But I just tried it out, and did verify that the line Me.Dirty = False does in fact save the record.
I made a simple form with a couple bound fields and a button that ran the Me.Dirty = False code. I changed one of the fields, checked the table, clicked the button, then checked the table again. The code had indeed saved the record. That's going to be a lot easier to remember than the DoCmd.RunCommand acCmdSaveRecord which I always had to search around to find because I couldn't remember the syntax on it. HTH, Toby ----- Original Message ----- From: "Hoffman, Tobi K (DYS)" <[EMAIL PROTECTED]> To: <AccessDevelopers@yahoogroups.com> Sent: Tuesday, November 22, 2005 7:44 AM Subject: RE: [AccessDevelopers] Re: updating a table from a form > Does setting > > me.dirty=false > > force Access to save the record? When I have needed to force a record > save, I've been using > > DoCmd.RunCommand acCmdSaveRecord > > which is somewhat more of a nuisance to type! > > Tobi > > <snip> > > doing nothing. Also, if you are expecting the number stored in the > table to > > be the new number that shows on your form you need to force the > form to save > > the current record. I would use: > > > > If me.dirty then me.dirty=false > > > > between steps one and two. > > > <snip> > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> 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/
