Populate Continuous Forms (1 Viewer)

Hi there.
I have Continuous Forms, to select article for customer, I have unbound text box to discount from total price. Example total price is $14, and I want to discount $4, after that i want $4 discount, to separate on article.
I have code to separate discount, but I can't populate all rows, on bound textbox, to save it on main table.
I try everything but not successed.
Can anybody help me to solve this?

On the form footer, is a textbox to sum the total: txtSubTot
=sum(txtAmt)

And a txtTotal box to sum txtSubTot and txtDisc.

TxtTotal=txtSubTot-txtDisc
On the form header is txtDiscount.

I have code to calculate discount: Discount=([Discount1]/[Sum1]*[Sum]), but I want discount to save on table.

I can't add discount on bound textbox, i try this:
Me.CalculateDiscount = Me.Discount
Me.CalculateDiscount.Value = Me.Discount.Value

CaclcuateDiscount is Bound TextBox.

This populate only one row on continuous form. Only row which I moved cursor to txt Discount1. I tried also to refresh form but not succesed.

Kallu said:

I want discount to save on table.

Click to expand...

Therein lies your problem! There very, very seldom is a reason to save calculated values to a Table and you shouldn't...you simply re-calculate it as needed, displaying in an Unbound Control (as suggested by Ranman256) whether in another Form or in a Report.

The exception to this rule would be if one or more components of the calculation are not actually Fields in the Record, but only referred to, using something like DLookup(), and I see nothing like that in your code.

A common example of this would be calculations involving tax rates, which can change over time, and a calculation done today, when viewing a Record form years ago, might not be accurate.

Linq ;0)>