By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,487 Members | 1,735 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,487 IT Pros & Developers. It's quick & easy.

Conditional Expression with CheckBoxes in Access

P: 1
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.
Jan 24 '08 #1
Share this Question
Share on Google+
1 Reply


MindBender77
100+
P: 234
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:
Expand|Select|Wrap|Line Numbers
  1. if textbox1 =  x then 
  2. CheckBox1.value = true
  3. else
  4. CheckBox1.value = false
  5. end if
  6.  
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
Jan 24 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.