calulated control not displayed in some circumstances

T

tricky300

Hi,

Thanks to anyone who can help.

I have a calulated control which is based on 3 other alterable controls on
a(continuous) form. I force display of the calculation by 'if me.dirty then
me.dirty=false' in the afterupdate of the 3 alterable controls. There is also
a total of this calculated control on the footer section which has the same
formula as the detail section except that it is inside a sum() function

When I update one of the alterable fields and the focus moves to any field
of the same record, the calculated control does not get refreshed with the
new value, however the total on the footer section does!!

If I update one of the alterable fields the and focus moves to any field of
a different record, the calculated control does get refreshed (as does the
total).

Is this an Access (2007) bug? Is there anyone who can suggest a workaround
or solution to this problem?
 
M

Mr B

In the AfterUpdate event of each control that you are entering data where you
want the calculation to take place, put the following code:

me.requery

--
HTH

Mr B
email if needed to:
draccess at askdoctoraccess dot com
 
Top