D Dorothy Nov 13, 2007 #2 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 (e-mail address removed)
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 (e-mail address removed)
