new_2_prog
Registered User.
- Local time
- Today, 05:12
- Joined
- Aug 4, 2008
- Messages
- 58
I have a field ControlsA on the main form which is a grand total field and the field subfrm_Total which is a total field off a subform within the main form so the control source is: =nz([Quote-2 subfrm].[Form]![grand_total],0).
As other fields on the main form are changed and loose focus a procedure AddControls is called to update ControlsA - works fine. But when I make changes to the subform the field subfrm_Total on the main form changes but ControlsA is not updated. So on field subfrm_Total I tried to use the Event Procedure "After Update" and "On Change" and entered the simple command Call AddControls to run the calculations update - doesn't work. I think this doesn't work because I am not physically changing the contents of the field subfrm_Total.
I need to call this procedure, how do I do it? I tried to do event procedure in the subform as the fields loose focus to call procedure AddControls but I am guessing because its in the main form the simple command Call AddControls doesn't work. I don't know how to call a procedure in another form.
Thanks!
As other fields on the main form are changed and loose focus a procedure AddControls is called to update ControlsA - works fine. But when I make changes to the subform the field subfrm_Total on the main form changes but ControlsA is not updated. So on field subfrm_Total I tried to use the Event Procedure "After Update" and "On Change" and entered the simple command Call AddControls to run the calculations update - doesn't work. I think this doesn't work because I am not physically changing the contents of the field subfrm_Total.
I need to call this procedure, how do I do it? I tried to do event procedure in the subform as the fields loose focus to call procedure AddControls but I am guessing because its in the main form the simple command Call AddControls doesn't work. I don't know how to call a procedure in another form.
Thanks!
