Jim Lawrence (AccessD)
accessd at shaw.ca
Thu Mar 18 20:34:07 CST 2004
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