How to do a discount

[Shooting Star]

Hi,

On my form, I want the user to be able to choose a discount from a dropdown box for example, and for the discount to be taken off of the subtotal;

The discounts are 0%, 5%, 10%, 15%, 20%.

So if the user selected 5%, then 5% would be taken off of the subtotal.

How would I go about doing this?

Thanks in advance,
Steven

 

[DCrake]

in your combo box have it set to either a table/query or a value list that will contain 2 columns

Value List

"5%";"5";"10%";"10";etc

Then when you want to calculate the %age use the value in your second column (column(1)) as your denominator, such as

Discount = (Me.SubTotal / 100) * Val(me.combo.column(1))


David