Control Source Issue

Z

zachnjoe

=IIf(IsNull([p1]),"",IIf(Val(Nz([Form]![PEN],0))<=Val(Nz([Form]![MAXPEN],0)
and Val(Nz([Form]![PEN],0))>=Val(Nz([Form]![MINPEN],0),"PASS","FAIL"))

This control source works until I add the "Val(Nz.... section. Once I add
that part I'm getting errors. Also, can this be simplified?
 
D

Douglas J. Steele

What error? [Form]![PEN], [Form]![MAXPEN], etc. don't look correct. They
should be something like Forms![FormName]![PEN], Form![FormName]![MAXPEN],
etc.

As well, you may want to use some parentheses in there, to make sure that
the comparisons get done correctly:

=IIf(IsNull([p1]),"",IIf((Val(Nz(Forms![FormName]![PEN],0))<=Val(Nz(Forms![FormName]![MAXPEN],0))
and
(Val(Nz(Forms![Form]![PEN],0))>=Val(Nz(Forms![Form]![MINPEN],0)),"PASS","FAIL"))
 
Top