Expression in Control giving error

[Jodith]

Actually, it's two problems.

I entered this expression: =IIf([Personnel File
Discrepancies]![PAF]="No","PAF","")
in a control. When I run the report, it's popping up a parameter input
window, and then where the control is on the report all I get is #error.

I'm seriously scratching my head. Anyone have any ideas? I used the
expression builder to come up with the expression.

 

[Duane Hookom]

Why are you including a table name in the expression? Is [Personnel File
Discrepancies] a table name in your report's record source? Is PAF a field in
your field list? Have you tried:
=IIf([PAF]="No","PAF",Null)