Theodore- Don't you have a form to edit Offers and Offer Details? Modify the offer first, then do the copy. If you already have the offer displayed, change and save it before copying it.
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 tyki9799 > Sent: Thursday, June 23, 2005 9:36 AM > To: [email protected] > Subject: [ms_access] Re: Moving records between tables > > > I see. What could I do if change some data on the current record > (current Offer) before I amend it to an Order so I would pass the new > data to the Order? That is, how do I update the current Offer record > before make it an Order? > > Theodore > > > > > > > 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/
