Put formula in field source control

[hdesbiens]

Hi

i have a datasheet that contains the taxes field calculated with the price of a piece,so i put in the control source of the field tax :=([subtotal]*[tax])

but i want to calculate the taxt only if the field notax is false, so is there a way to put in the control source of my field tax that will calculate only if the field notax is false?

thanks

 

[PHV]

Perhaps this ?
=IIf([notax]=False,[subtotal]*[tax],0)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886