MarkH
lists at theopg.com
Mon May 3 10:33:22 CDT 2004
Perfect, thanks :@) Mark -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: 30 April 2004 21:51 To: Access Developers discussion and problem solving Subject: RE: [AccessD] Sub form updates not immediately visible to parent Mark, Add a dbEngine.Idle after refreshing the subform records and just before you do the calculations. This will force JET to finish up it's background tasks before continuing with code execution. Jim (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of MarkH Sent: Friday, April 30, 2004 3:23 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Sub form updates not immediately visible to parent Hi all Using AXP in WinXP I have a very complex form and subform where the parent performs calculations based, partly on, records accessed through the subform. Inclusion of the subform records in the calcs is dependant on a yes/no field being set to yes. On the parent is a button which refreshes the calcs. If I change the subforms yes/no value and then click the refresh button on the parent straight away, the change is not always reflected in the calculations. If I wait 5 or 6 seconds (working on a local backend) then everything is fine. I have spent a lot of time trying to simplify the code (the refresh button being a result) but no matter what there is still a delay resulting in the calcs not always being refreshed properly. I tried requerying and saving in the subform both after the edit and when the refresh button is clicked but I still get the same problem. Any one got any pointers, I'd be real greatful. Thanks and have a good weekend (I'm off at last) Mark -- _______________________________________________ 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