Don Elliker
delliker at hotmail.com
Thu Jul 24 10:46:05 CDT 2003
Hey, Thanks - I got it going. Page 492 in the ADH for A2K has a very good write-up on this. It's soo easy to question the List though , I just automatically go there first. _D "Things are only free to the extent that you don't pay for them".-Don Elliker >From: "Mark H" <lists at theopg.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "'Access Developers discussion and problem >solving'"<accessd at databaseadvisors.com> >Subject: RE: [AccessD] creating an inputbox form >Date: Thu, 24 Jul 2003 16:34:50 +0100 > >I declare a global variable (e.g. retVal) and set it when the input form >is closed. > >The next line of code in the calling form can then read retVal to >wherever its needed. Make sure you clear retVal when the input form is >loaded though to ensure you don't pick up old selections... > >Hth > >Mark >PS sorry if this has already been suggested, I missed parts of this >thread... > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte >Sent: 24 July 2003 15:50 >To: accessd at databaseadvisors.com >Subject: Re: [AccessD] creating an inputbox form > > >Don, > >I would find where the command is to CLOSE your inputbox form...and >right >before that...save the value to where ever you are going to store >it...even >back to a field on the form that launched the inputbox. >ex: > > Forms!form1!Text0 = Me!Text0 > DoCmd.Close > > >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus