Check boxes and calculations

[Viv_500]

I would like a checkbox to contain whether a company is situated abroa
or not, if the checkbox is ticked then the balance (currency data type
text box (on the same form, in the same table) shows the balance minu
VAT. Where would this code need to be and how would it look?

Thanks, Vi

 

[Microsoft News Groups]

Viv,

VAT is presumably a percentage of the cost. You could use a controlsource
such as =IIf(chkOverseas=True, Cost, Cost*(1+VatPercentage/100)).

If VAT and Cost are stored separately then you could use
=IIf(chkOverseas=True,Cost,Cost+VAT)

The IIf function has the form IIf(Condition, Value if True, Value if False)

Rod Scoullar