DWUTKA at marlow.com
DWUTKA at marlow.com
Thu Mar 30 17:39:28 CST 2006
Open that form modally. That will pause the running code that called it. Drew -----Original Message----- From: Tom Keatley [mailto:tom.p at piedpiper.com.au] Sent: Thursday, March 30, 2006 5:33 PM To: Access Developers discussion and problem solving Subject: [AccessD] Halting Execution of Function when form opens and resuming afterwards Hi all..... I have a function(1) that is looping through customer records and calling another function(2) during each iteration to re-calculate what that customer owes... If the function(2) finds an imbalance between what was previously calculated and what is being calculated now I have it opening a form showing the two sets of calculations to allow the amounts to be edited. The criteria for opening the form is actually part of the 2nd function This works fine when used for a single customer but as part of the above loop the form pops up when it is needed but the loop continues to execute behind it How can I make the execution of the loop suspend until I close the form? and then continue..... As always any help would be appreciated Regards Tom Keatley -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com