enter zero or function

[wthoffman]

I have a field "TaxExempt" which is set with a yes/no drop down box. When a
"no" has been entered into the field I want the following to happen:
AmountSubjectToTax: [salesPrice]-[TradeInAllowance] if a Yes is entered jnto
the taxExempt field I want to return a zero.
Help

 

[Jeff Boyce]

I'm confused about how you've set this up, and where...

A yes/no field and a "drop down box" seem to be two different beasts. And
is this directly in a table, or are you working in a form (recommended)?

If you are working in a form, you can utilize the AfterUpdate event to set
other controls' values with an expression much like what you posted.

More info, please...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Al Campagna]

wthoffman,
Since all the elements of the calculation are already captured to a
table, AmountSubjectToTax would be an unbound calculated field, and not
stored to your table.
I'm also assuming that TaxExempt is a text field, and not a Boolean
True/False.

In the ControlSource of a text control named AmountSubjectToTax...
= IIF(TaxExempt = "No", [SalesPrice] - [TradeInAllowance], 0)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."