martakeithy
Technical User
Hi all,
I hope you can give me some advice. I have a problem with a form and subform. The main form contains customer details, such as bank details and the total cost of purchases made by the customer. The subform records each payment.
The subform has a field for total, which is what is outstanding before the payment, a field for the amount paid, a field for the payment date and a field for the new balance after the payment has been subtracted.
Each customer makes four or five payments. The way I have the subform set up is that the payment is subtracted from the total giving a new balance, with the date of payment filled in by the date function.
For the first payment of the four or five payments, I would like to take the total cost of purchases from the main form and put that value in the subform textbox total. This would allow me to subtract the payment from the total and give a new balance.
The next problem is that I would like all of the following payments to have the new balance value from the last payment made to appear at the start of the next payment, that way I can subtract the payment and get the new value.
I am probably doing this in strange way, but my programming skills are very limited.
Can anyone suggest a way of doing this?
I would appreciate your advice
Regards
Marta
I hope you can give me some advice. I have a problem with a form and subform. The main form contains customer details, such as bank details and the total cost of purchases made by the customer. The subform records each payment.
The subform has a field for total, which is what is outstanding before the payment, a field for the amount paid, a field for the payment date and a field for the new balance after the payment has been subtracted.
Each customer makes four or five payments. The way I have the subform set up is that the payment is subtracted from the total giving a new balance, with the date of payment filled in by the date function.
For the first payment of the four or five payments, I would like to take the total cost of purchases from the main form and put that value in the subform textbox total. This would allow me to subtract the payment from the total and give a new balance.
The next problem is that I would like all of the following payments to have the new balance value from the last payment made to appear at the start of the next payment, that way I can subtract the payment and get the new value.
I am probably doing this in strange way, but my programming skills are very limited.
Can anyone suggest a way of doing this?
I would appreciate your advice
Regards
Marta
