Conditional Expression with CheckBoxes in Access

[GMAN36]

I have a problem which may be simple to solve...not sure (teaching myself Access using Access 2002).

I have a field [total] that performs the calculation =[qty]*[price]
however, sometimes the item is not taxable. I want to add a CheckBox to show whether the item is taxable or not. When the CheckBox is checked it means that the item is not taxable and I want the [total] value to appear in another field [nontax]. If the CheckBox goes unchecked then the calculation is performed and the value stays in the [total] field.

Can this be done using a checkbox? or is there anyway way I should go about it.

Any help you can lend would be great.

[MindBender77]

I have a problem which may be simple to solve...not sure (teaching myself Access using Access 2002).

I have a field [total] that performs the calculation =[qty]*[price]
however, sometimes the item is not taxable. I want to add a CheckBox to show whether the item is taxable or not. When the CheckBox is checked it means that the item is not taxable and I want the [total] value to appear in another field [nontax]. If the CheckBox goes unchecked then the calculation is performed and the value stays in the [total] field.

Can this be done using a checkbox? or is there anyway way I should go about it.

Any help you can lend would be great.

You could use an IF statement. Something like:

if textbox1 =  x then 
CheckBox1.value = true
else
CheckBox1.value = false
end if
 

You could indicate whether an item is taxable by say, a label that will be invisible until the item is not taxable and then it becomes visible.

Hope this leads you in the right direction,
JS