John W. Colby
jwcolby at colbyconsulting.com
Thu Mar 18 20:23:06 CST 2004
Any time you open a form modal, processing stops in the code that opens that form. It's just automatic, and is one of the parameters of the docmd.open form syntax. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren DICK Sent: Thursday, March 18, 2004 9: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