return column values with IIF

  • Thread starter Thread starter RICK
  • Start date Start date
R

RICK

I have the following as a "control source". I get #error. What could be
wrong?

=IIf(IsNull([SumOfAmount]),[PIFunds],(IIf([AmountType]=1,[PIFunds],"")))
 
RICK said:
I have the following as a "control source". I get #error. What could be
wrong?

=IIf(IsNull([SumOfAmount]),[PIFunds],(IIf([AmountType]=1,[PIFunds],"")))
Click to expand...


I suspect that the problem is that the text box is named
either SumOfAmount, AmountType or PIFunds. If so change its
name to something else.

It's also possible that #Error is being propogated from one
of the other text boxes that also has #Error
 
Back
Top