Enter parameter value when fields are correct

[grahamYSA]

HI, hope this isn't a dumb question, I am a newbie.

I have used the Data tab on a property sheet for a field in a report to build this expression (using expression builder) as the control source "=IIf([AllSchoolContacts].[Email]>" ",[AllSchoolContacts]![Email],[EmailAddress])" When I view the report I get the Enter Parameter Value dialog labelled AllSchoolContacts
I have added the fields to the expression using the expression builder the sources for the report are a table and a query in the REPORT.


The tables are AllSchoolContacts and Non Metro Query.

What I am trying to do is to have the record line show the email address for the organisation if the email address field in the AllSchoolContacts is blank.

Hope someone can help!

[June7]

Blank field can be either Null or empty string. They are not the same thing. I do not allow empty string in table fields. Most likely your field is Null.

Try using Nz() function.

Nz([Email], [EmailAddress])

Can do this calc in query and bind textbox to the constructed field or put the expression in textbox.