Check boxes and calculations

  • Thread starter Thread starter Viv_500
  • Start date Start date
V

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
 
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
 
Back
Top