Form footer total

[Jishnu Surendran]

My form footer total "=Sum([Field]" takes some time to respond. What may be the reason? I am using "if me.dirty=true then me.dirty=false" as afterupdate event for the respective field.



The lag is not happening in the 'form detail'. It is usually happening in the 'form footer'. The record source of the form is a table. The sum value is not taken to the table. It is used for indicative purpose only.

[ranman256]

i find "if me.dirty=true then me.dirty=false" useless and remove them.
I get a 1 second lag when it calcs SUM in the footer as expected, since it does have to sum.
What kind of lag are you seeing? I wouldnt worry.

[Jishnu Surendran]

The time taken to sum the fields in the 'form footer' differs from the time taken in 'form detail' for the same process. However, the VB code is used not to make it faster but to update the sum when I leave the respective field, otherwise it is updated only after I finish the record.