Contents of a field based on the contents of another field

[p595659]

Hi,
I'm making a form where the contents of a field is determined on the contents of another field in another form. I thought an IIF function would work, but when I tried it the contents says #NAME.

I put it in the control source.

IIF([Forms]![Frm_NewBusiness]![Page4]![Child51]="NTU",NewBusiness_Date_Issued="NTU",NewBusiness_Date_Issued)

Any ideas?

Cheers,
Ben

 

[mhartman]

Hello
What that means is you entered an ambiguous name for the control. In other words the control does not know what this item is.
'
You need the verify all your names in your statement. I have taken a wild guess as noted below:
'
IIF([Forms]![Frm_NewBusiness]![Page4]![Child51]="NTU","NTU",NewBusiness_D ate_Issued)
'
Regards
Mark