Command Button

[tia]

I have 4 fields in a form:


Actual Price
Discount Rate
Price Discount Value
Price After Discount

Scenario: The Actual price and Discount rate needs to be inputted manually.
After typing the values in the actual price and discount rate, the customer needs to hit the Command Button named Calculate so that data will be displayed in the two other fields: Price Discount Value (Price Discount Value = Actual Price * Discount Rate) and Price After Discount (Price After Discount = Actual Price - Price Discount Value).

What will I do so that once the customer clicks the Calculate button, the values in the Price Discount Value and Price After Discount will be displayed.

What will I do in the on click event, what to choose (macro/expression or code buider)? What will I type?

Thank You

[pdebaets]

I don't think you need a button. In the control source of your Discount Value control, put

=nz([Actual Price],0) * nz([Discount Rate],0)

In the control source of your After Discount control put

=nz([Actual Price],0) - nz([Discount Value],0)