In Access 2000, I have a subform which contains payments related to an order. In the hidden footer of this subform is a "total" payments calc in a text control called Text10. Out on the main order form, a text control called TotalPaid is set up so that as payments are added to the subform, TotalPaid automatically reflects the changing value of Text10. (The control source for TotalPaid is =[AuctionPmt Subform].[Form]![Text10].[Value].)
Now... I need an Event Procedure to trigger whenever the TotalPaid control changes. So, naturally, I used the control's On Change event -- but as I addd and delete payments in the subform in order to alter the value of TotalPaid, the Event doesn't happen. Using the On Update event doesn't work either.
Which event method should I be using? Bear in mind that the value in the TotalPaid control is not changed manually by the user, at least not directly. Is that why I am having difficulty?