[AccessD] Halting Execution of Function when form opens and r esuming afterwards

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



More information about the AccessD mailing list