Formula in a form

[vgeng]

I have next formula in my form :

=Sum(IIf([check]=Yes;[IN];0))

Access only recalculate the formula when I select
another record

Isn't there a possibilty to recalculate the result at the moment I change the checkbox [check] from No to Yes ?

Thanks

Gette

 

[RoyVidar]

Hi!

Try to add a

[tt]me.recalc[/tt]

in the after update event of the checkbox (forces recalculation on all calculated controls on the form)

Roy-Vidar

 

[Yarcadian]

Try adding this to the ON UPDATE for the check box:

if me!check = -1 then
[field name]= sum([in])
else:
[field name] = 0
end if

David

 

[vgeng]

Problem solved

Thanks

G