Form developed in Access 2003 losing functionality in Access 2002

[Guest]

I have a form with a subform which records details of course bookings for
each customer on the parent form.

I have two buttons on the subform which will add or delete a new record. I
have customised these so that when a new record is added or deleted in the
sub form then the total spend in the main form is recalculated (I recalculate
the form using Me.Parent.Recalc in the code of each button). This works OK
when I run the applicaton on my machine with MS Access 2003. However, when I
run the application on my customer's machines using MS Access 2002, I get a
problem. The save record button works fine, but the delete record button
only deletes the record. It fails to recalculate the totals on the main
form.

Can anyone please shed light on this? Thanks in advance.

Peter

 

[Allen Browne]

This sounds like a timing issue.

There were issues with A2002 (particularly SP3) losing track of the current
record in some of the deletion events.

Try adding a DoEvents to the command button's Click event procedure to give
Access a chance to catch up. Place it between after the deletion and before
the ReCalc.

 

[Guest]

Thanks again Allen. I can't test it for a couple of days, but will let you
know the result.

Peter