How to do this

[Vu_Ho]

My question is this:
I have several controls:
[Order_Type] with 3 values: Regular, Rush and Extremely Rush, [Unit_Price], [Quantity] and [Total]
By default: [Total]=[Unit_Price]*[Quantity]
What I want is when [Order_Type]="Rush" then [Total] would be:[Unit_Price]*[Quantity]+20 and if [Order_Type]="Extremely Rush" then [Total] would be: [Unit_Price]*[Quantity]+30
What would be the code for this?

 

[pbaldy]

I would maintain the types in a table along with the additional amount. I'd use a combo to let the user choose the type, and the combo row source would include the amount. Then your calculation is

[Total]=([Unit_Price]*[Quantity]) + Order_Type.Column(1)

getting the amount from the second column of the combo.