I need 2 answers in control source?? Either or???

[Guest]

On my database i have totals which automatically add VAT for me but some of
my customers are tax excempt. I need Vat to be added except when i put a
number in my CIF ( name of one of my fields) field.
Does that make sense???

Also is it possilble to have a drop down box on one of my feilds with 2
choices, like either or????

 

[fredg]

On my database i have totals which automatically add VAT for me but some of
my customers are tax excempt. I need Vat to be added except when i put a
number in my CIF ( name of one of my fields) field.
Does that make sense???

Also is it possilble to have a drop down box on one of my feilds with 2
choices, like either or????

In an unbound control's Control Source:
=IIf(IsNull([CIF]),[Cost] + VAT,[Cost])

Yes it is possible have a combo box with 2 choices.
Set the Combo box RowSourceType property to Value List
Set the RowSource to:
"Choice1","Choice2"