scouser
Registered User.
- Local time
- Today, 08:09
- Joined
- Nov 25, 2003
- Messages
- 767
Hi to all. In the attached database I have calculated fields on frmSalesOrders 'Order Balance' and subform frmPayments 'Total Payment' 'Order Balance' and hidden field 'SumPayments'.
At present users must enter a blank payment for the calculated fields to populate (see attached Payment Form Blank Entry).
I would like the values to populate without the need to enter a blank payment and for the Order Balance on frmSalesOrders to update after each Sales Order Item is entered.
Any help appreciated.
Many Thanks,
Phil.
At present users must enter a blank payment for the calculated fields to populate (see attached Payment Form Blank Entry).
I would like the values to populate without the need to enter a blank payment and for the Order Balance on frmSalesOrders to update after each Sales Order Item is entered.
Any help appreciated.
Many Thanks,
Phil.