Tupacmoche
Registered User.
- Local time
- Yesterday, 20:15
- Joined
- Apr 28, 2008
- Messages
- 291
This problem is from the post 'Write Conflict' which needs its own post and attention. The original issue was using subforms on the same data source which caused a 'Write Conflict' This was resolved by using a tabbed control on the main form to logically segregate data.
But this has created a new issue. The following expression worked perfectly before the tabs and now is not:
=Sum(Nz([PP1_Amt])+Nz([PP2_Amt])+Nz([PP3_Amt])+Nz([PP4_Amt])+Nz([PP5_Amt]))
See attached file.
It simply adds up the payment above using the 'On Got Focus' event. But now it has a value in it even before anything is entered into the payment amounts. How can this be fixed? How can I restrict it to the current record?
But this has created a new issue. The following expression worked perfectly before the tabs and now is not:
=Sum(Nz([PP1_Amt])+Nz([PP2_Amt])+Nz([PP3_Amt])+Nz([PP4_Amt])+Nz([PP5_Amt]))
See attached file.
It simply adds up the payment above using the 'On Got Focus' event. But now it has a value in it even before anything is entered into the payment amounts. How can this be fixed? How can I restrict it to the current record?