Thanks Chris that was spot on. Also discovered by accident once it was working that Me.Refresh can have the same result.
Alex ---------------------------------------------- Alexander Shaw Agricultural Stock and Assignment Photography > -----Original Message----- > From: chris lewis [mailto:[EMAIL PROTECTED]] > Sent: 18 June 2002 00:45 > To: Alexander Shaw > Cc: [EMAIL PROTECTED] > Subject: Re: MS Access forms and auto numbers > > > Try using this in a code builder window: > DoCmd.RunCommand acCmdSaveRecord > > Make sure that your table has a TimeStamp field configured. If it isn't > there, Access will say that the record was deleted. I'm not sure if you > need to requery the form or not. It's been 2 years since I last worked > with a form like that. > > Chris > > ------------------------- > Original Message > ------------------------- > From: Alexander Shaw <[EMAIL PROTECTED]> > To: MySQL Win 32 List <[EMAIL PROTECTED]> > Subject: MS Access forms and auto numbers > Date: 15 Jun 2002 09:32:15 +0100 > Hi, > > I'm trying to upsize an application to MS Access front-end and a MySQL > backend. The problem I'm encountering is that some of the data written > from > a bound form depends on an auto-number field, which in the case of MySQL > isn't updated from Null until the record is written by moving onto the > next > new record. > > So in effect what I would like to do is force the record to be written > in > the after-update event of an object on the form so that either the form > or > corresponding text box with the auto-number displayed can be updated so > the > data 'exists' for the later writes to take place. > > I'm sure this should be pretty simple but haven't been able to find > anything > about it. Any suggestions gratefully received. > > Alex > ---------------------------------------------- > > Alexander Shaw > Agricultural Stock and Assignment Photography > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.371 / Virus Database: 206 - Release Date: 13/06/2002 > > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.371 / Virus Database: 206 - Release Date: 13/06/2002 > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.371 / Virus Database: 206 - Release Date: 13/06/2002 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php