how to make my Payment Section with Tendered and Change textbox.

[markpastoril]

I would like to have my Payment section to function like cashier. When the Cashier inputs the Amount/ of the Customer they pay in the Tendered textbox, the form calculates the Amount to be Paid and Calculates the Change.Like this.



Total Amount Due: 150.00

Amount tendered: 1,000 (the amount the customer gives to the cashier)

Change: 850.00 (auto calculates when the Cashier/User enters the Amount Tendered.)

The Amount Tendered and the Change text box is still unbound coz i did not have a field on any of my table.
Question?do I have to create a field for it?and I need the code with this.please help.

This is my system looks like.

Attachment 35851

[ranman256]

unbound text box, with the formula:
txtChg = txtTender - txtAmtDue

[markpastoril]

where to put the code?the amount_tendered , change and amount paid is a bound field,how do I put exact amount equals to the balance so balance will be equals to 0 after posting the payments details/information.

[Micron]

This looks like a cross posting in this forum. I guess I wasn't getting through over here

https://www.accessforums.net/showthread.php?t=74117