G
Guest
I am attempting to reference summary totals on a subform from the current
record event of the main form. Running the subform independently produces
the desired values. The attempted reference form the main form, it appears as
though a null value is returned. If a breakpoint is place on the referencing
statement, an error indicates an automation error occured, and #ERROR appears
in the Sum(xxxx) fields. After some experimentation I found by placing a
timer event to delay the reference of the subform totals every thing worked
fine. The problem with this solution it still fails when the subform is
working on a large number of records. Obviously a large timer value solves
this problem but makes the performance appear very slow.
Question: Is there a method to insure synchronization of the completed
subform calculation and then the main form reference of the result ?
Platforms: Win98se, Win2k and WinXP
Programs: Access97, access2k and access2003 (Similair errors in all)
Hardware: Pentium M centrino 1.7Ghz
Please Email to:
(e-mail address removed)
Thank you
record event of the main form. Running the subform independently produces
the desired values. The attempted reference form the main form, it appears as
though a null value is returned. If a breakpoint is place on the referencing
statement, an error indicates an automation error occured, and #ERROR appears
in the Sum(xxxx) fields. After some experimentation I found by placing a
timer event to delay the reference of the subform totals every thing worked
fine. The problem with this solution it still fails when the subform is
working on a large number of records. Obviously a large timer value solves
this problem but makes the performance appear very slow.
Question: Is there a method to insure synchronization of the completed
subform calculation and then the main form reference of the result ?
Platforms: Win98se, Win2k and WinXP
Programs: Access97, access2k and access2003 (Similair errors in all)
Hardware: Pentium M centrino 1.7Ghz
Please Email to:
(e-mail address removed)
Thank you