[MS_AccessPros] Subform return error

 

I have a subreport that has a client's email address(es). I want a formula that will return in the a text box in the main report a note saying the following:
"Please provide your email:_______________"

I am using a formula in the main report with data on that main report (not on a subform) and it is working great:
=IIf([NAME] Is Null,"Name:_____________","")

The name of the subreport is: Report.SUBRPT CORREO ELECTRONICO
The name of the field within the subreport is: CORREO ELECTRONICO

"Is null" is not working because when the Email subreport has nothing in it, there is nothing that happens with the formula.

Thanks in advance for any advice.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5
• New Files 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___