#Name? error message

  • Thread starter Thread starter tc2004
  • Start date Start date
T

tc2004

I added an unbound text box to my form and the following expression. When I
go back to Form View I get the following error message: #Name?

Here is the expression:

=IIf((IIf([tbl_Demographics]![dtDateReConsented] Is
Null,[tbl_Demographics]![dtDateFirstConsented],[tbl_Demographics]![dtDateReConsented]))<#4/17/2009#,(IIf([tbl_Demographics]![dtDateReConsented]
Is
Null,[tbl_Demographics]![dtDateFirstConsented],[tbl_Demographics]![dtDateReConsented]))+5*365,(IIf([tbl_Demographics]![dtDateReConsented]
Is
Null,[tbl_Demographics]![dtDateFirstConsented],[tbl_Demographics]![dtDateReConsented]))+10*365)

I originally had this in a query and it worked just fine there, but copying
the code to the form did not work. What is going on?

Thanks.
 
I can not follow the logic of these IIF statements --
=IIf((IIf([tbl_Demographics]![dtDateReConsented] Is Null,
[tbl_Demographics]![dtDateFirstConsented],
[tbl_Demographics]![dtDateReConsented])) <#4/17/2009#,
(IIf([tbl_Demographics]![dtDateReConsented] .....

This is saying if dtDateReConsented is null test dtDateFirstConsented but
there is no test criteria.

Can you verbalize the process?
 
Back
Top