Field recalc

D

Dorothy

Hi

How can I force a calculated form field to reclac?

Thanks

Regards
Click to expand...

Hello. You can use a VBA code for AfterUpdate. What this does is
after a field is updated, it runs the code to recalculate the form.

For example, let's say the field you want to recalculate is me.field1
and let's say the field you populate to recalc this field is
me.field2.

Here's the code for me.field2 you want.

Private Sub field2_AfterUpdate(Cancel As Integer)

write your code in here to recalculate me.field1

End Sub


Good luck!

Dorothy
[email protected]
 
Top