history
Egyptian Pharaoh
- Local time
- , 02:40
- Joined
- Jan 26, 2008
- Messages
- 190
Hi Brothers,
I've a Sale Invoice form contains : Invoice No. , Invoice Date , Customer Name , Customer debts (Number) , Customer credits (Number) ,,,,,, etc.
The field Customer Name is a combo box, it's row source is query contains :
Customer Name , Amount , Status(Debt,Credit)
I need to get the data from Amount and put it in Customer debts or Customer credits according to it's status.
So I think On After Update Event of Customer Name some code can be put.
Thanks in advance
I've a Sale Invoice form contains : Invoice No. , Invoice Date , Customer Name , Customer debts (Number) , Customer credits (Number) ,,,,,, etc.
The field Customer Name is a combo box, it's row source is query contains :
Customer Name , Amount , Status(Debt,Credit)
I need to get the data from Amount and put it in Customer debts or Customer credits according to it's status.
So I think On After Update Event of Customer Name some code can be put.
Thanks in advance