[AccessD] A2K: Stop Code, Accept Input then restart code

Thanks John and Jim
I'll give it a go (both) methods

Darren


----- Original Message ----- 
From: "Jim Lawrence (AccessD)" <accessd at shaw.ca>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Friday, March 19, 2004 1:34 PM
Subject: RE: [AccessD] A2K: Stop Code, Accept Input then restart code


> Hi Darren:
> 
> Run the second or third form from the 'on timer' event that should allow
> multiple processes to run or/and use the DoEvents..
> 
> <code>
> globalvariable1 = True
> DoCmd.OpenForm "Form2"
> 
> Do While globalvariable1 = True
>    DoEvents
> Loop
> 
> DoCmd.Close ,"Form2", acSaveYes
> </code>
> 
> This will hold things relatively static until any process unsets the global
> variable.
> 
> HTH
> Jim
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren DICK
> Sent: Thursday, March 18, 2004 6:06 PM
> To: AccessD List
> Subject: [AccessD] A2K: Stop Code, Accept Input then restart code
> 
> 
> Hello all
> I have code on Form 1 that alerts the user to something
> What I want to do is half way through the alert code, stop the alert code,
> open form 2 (a popup form)
> Allow user to select a value from a combo on Form 2. Close form 2 then pass
> that value from Form 2
> back to the Alert code on Form 1 and continue processing the Alert code
> using the value passed from Form 2
> 
> What I don't know how to do is...Stop processing the Alert Code in Form 1 -
> I do know how to get ....A value from Form 2
> What I don't know how to do is...Start processing the Alert Code in Form 1
> again with the new value
> 
> Make sense? Am I going about this the right way?
> 
> Many thanks in advance
> 
> Darren
> 
> 
> 
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com