Mark H
lists at theopg.com
Thu Jul 24 10:34:50 CDT 2003
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