field update problem

[dickminter]

I apologize for any violation of protocol, but I've not
gotten a response on the Office Developer/VBA group, so
I'm trying here.

I have a form with two linked subforms. A sub procedure
triggered by the after_update event in subform_2 modifies
a value in field_A in subform_1. An unbound control on
the main form recalculates when field_A updates.
Problem: I don't think the after_update event fires when
the value is modified by the subform_2 procedure, because
the calculated control isn't updating. A recalc command
in the Subform_2 procedure has no effect. How can I
programatically commit the change, i.e. cause the
after_update event for the modified field to fire?

DM

 

[John Vinson]

How can I
programatically commit the change, i.e. cause the
after_update event for the modified field to fire?

You can explicitly call the After_Update sub:

Call controlname_AfterUpdate()