return column values with IIF

[RICK]

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

=IIf(IsNull([SumOfAmount]),[PIFunds],(IIf([AmountType]=1,[PIFunds],"")))

 

[Marshall Barton]

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

=IIf(IsNull([SumOfAmount]),[PIFunds],(IIf([AmountType]=1,[PIFunds],"")))

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