IIF statement problems in a report

[Guest]

For my database I am attempting to do two things:
1. Typically tax can be calculated based on state(very easy)
2. Occasionally tax can be exempt or a couple of other conditions that make
tax not computable for this DB so I created a check box that displays an
input box for these situations. A calculated tax amount can be typed into
the box which saves the value in a typically blank field in my table. I have
tried using the following statement to tell the report which calculated
amount to use based on the situation. This statement is in the control
source property

=IIf(IsNull([Tax]),[txtSubTotal]*[Selected project
contact].Form!TaxRate,[Tax])

When the form is reviewed all that is displayed is "#Name"
Thank You,
Mike Konopinski

 

[Guest]

I dont understand, if this iif statment placed in a report then it should be

=IIf(IsNull([Tax]),[txtSubTotal]*[Selected project
contact].Report![TaxRate],[Tax])
If the field TaxRate placed on the report

But if the field TaxRate placed in a form then the syntax should be
=IIf(IsNull([Tax]),[txtSubTotal]*Forms![Selected project
contact].Form![TaxRate],[Tax])