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> ------------------------ 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/