[AccessD] creating an inputbox form

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




More information about the AccessD mailing list