Solved Subtraction from the continuous form

[FahadTiger]

Hi Experts..
I have a continuous form representing customer invoice amounts
When I receives a certain amount, its subtracts the amount of each invoice ... and the rest represents the remaining amount of the last invoice
as shown in attachment
any advice plz

 

[theDBguy]

Hi. Not entirely sure but maybe you could try this?

Code Snippets

 

[FahadTiger]

Hi. Not entirely sure but maybe you could try this?

Code Snippets

thanks theDBguy for replying
but I dont know how can I used it

 

[theDBguy]

thanks theDBguy for replying
but I dont know how can I used it

Perhaps if you could post some sample/test data to help us understand better what you're trying to do. Try to give us a before and after picture of what you want to happen.

 

[FahadTiger]

Perhaps if you could post some sample/test data to help us understand better what you're trying to do. Try to give us a before and after picture of what you want to happen.

when the user open the form ..its appears the whole invoices of customer(1) which not pay them
when the user recieve some of payment in txtPayment ..its subtract from each invoice
as shown in figure

 

[theDBguy]

when the user open the form ..its appears the whole invoices of customer(1) which not pay them
when the user recieve some of payment in txtPayment ..its subtract from each invoice
as shown in figure

Hi. No offense, but I can look at that picture all day long and still not have any idea what you're asking. It's better if we had actual data to play with. Like I said, a before and after set of data would be nice.

 

[FahadTiger]

this is an example of my database

 

[theDBguy]

this is an example of my database

Thank you. Please give this one a try.

 

[FahadTiger]

Thank you. Please give this one a try.

thank you so much sir
im writing the same code but i mistake in else statement
thank u again

 

[theDBguy]

thank you so much sir
im writing the same code but i mistake in else statement
thank u again

You're welcome. Good luck with your project.