Calculate in Subform

[EliteDesk@aol.com]

I have a sub form,Default View Continuous, with an unbound text box TotalPay control source =[Percentage]/100*Charge but I need to change TotalPay to something like...

If Me.Request.Value = True then
Me.TotalPay = [Percentage]/100*[Charge]
Else
Me.TotalPay = [PercentageReq]/100*[Charge]
End If

Where should the code be placed? Any help would be greatly appreciated!

 

[stopher]

No need for code. You can just change the formula in TotalPay control source to:

IIF(me.request.value=true, [Percentage]/100*[Charge] ,[PercentageReq]/100*[Charge])

The IIF function works like the IF function in Excel.

hth
Stopher

 

[EliteDesk@aol.com]

THANKS! its just want I needed!