T
Thomas Kroljic
I am occasionally running into a problem on a subform. The user will get
The following message in all input fields: #ERROR.plus a "circle with a
slash" appears in the left hand corner of the record.
I have an Access 2000 mdb running on a w2k server. This application has been
running for the last two+ years. It is only within the last 6 months that
this error
is occurring (not sure what changed 6 months ago if anything). The form is a
typical parent form with a subform. The subform allow
the user to enter in line items (purchase items). In the footer of the
subform, I keep a
running SUM of the total price of all line items entered. After each line
item in the
"After Update" event, I call a sub procedures in the parent form to
recalculate taxes, sub-totals, and totals that are on the parent form.
Within the recalculation process, it references the SUM field on the
subform. Is it possible that the recalculation process is running before the
SUM field on the subform is finished updating itself? Would this be causing
my problem?
If I slowly enter the data into the subform, everything works OK. It appears
that if I quickly enter the line item (in this case a SKU number) and hit
the enter key through the remaining input fields (none of these fields are
mandatory) to go to the next line, the error appears. Coincidence?
I'm at a lost as to where to look. Even if I'm the only one on the system, I
can get this error to appear. Any suggestions on how I can track this
problem down? I've used the debugger to step through the code but it hasn't
shed any light on the problem. I'm concerned that maybe the data entry is
going to fast for the subform to SUM the total price which is used in the
recalculation procedure.
Thank you,
Thomas J. Kroljic
The following message in all input fields: #ERROR.plus a "circle with a
slash" appears in the left hand corner of the record.
I have an Access 2000 mdb running on a w2k server. This application has been
running for the last two+ years. It is only within the last 6 months that
this error
is occurring (not sure what changed 6 months ago if anything). The form is a
typical parent form with a subform. The subform allow
the user to enter in line items (purchase items). In the footer of the
subform, I keep a
running SUM of the total price of all line items entered. After each line
item in the
"After Update" event, I call a sub procedures in the parent form to
recalculate taxes, sub-totals, and totals that are on the parent form.
Within the recalculation process, it references the SUM field on the
subform. Is it possible that the recalculation process is running before the
SUM field on the subform is finished updating itself? Would this be causing
my problem?
If I slowly enter the data into the subform, everything works OK. It appears
that if I quickly enter the line item (in this case a SKU number) and hit
the enter key through the remaining input fields (none of these fields are
mandatory) to go to the next line, the error appears. Coincidence?
I'm at a lost as to where to look. Even if I'm the only one on the system, I
can get this error to appear. Any suggestions on how I can track this
problem down? I've used the debugger to step through the code but it hasn't
shed any light on the problem. I'm concerned that maybe the data entry is
going to fast for the subform to SUM the total price which is used in the
recalculation procedure.
Thank you,
Thomas J. Kroljic