Prev: Version Updates
Next: A Great Big Thank You!
From: Gntlhnds on 27 May 2010 16:49
Never mind, now it works. I don't have a clue why, but it does. Oh well.

"Gntlhnds" wrote:

> I have two identical forms, each with a DOB field and an Age field. I'm
> using the following expression to display the age in each form:
>
> =DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd"))
>
> On one form, it works perfectly. In the other form, I get a #Name? error.
> Why would it work in one form, but not the other? I was wondering if it was
> a formatting difference for the DOB field, but that isn't it. Thanks for
> thelp.
From: Daryl S on 27 May 2010 16:54
Gntlhnds -

One guess here... It could be the [DOB]. Is this a field name in the
underlying query for both forms? If you are referencing a control on a form
(e.g. the textbox is named [DOB], then use Me.[DOB]. Maybe the textbox on
the second form is called txtDOB or DOB1, where you should use Me.[txtDOB] or
Me.[DOB1]...

--
Daryl S


"Gntlhnds" wrote:

> I have two identical forms, each with a DOB field and an Age field. I'm
> using the following expression to display the age in each form:
>
> =DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd"))
>
> On one form, it works perfectly. In the other form, I get a #Name? error.
> Why would it work in one form, but not the other? I was wondering if it was
> a formatting difference for the DOB field, but that isn't it. Thanks for
> thelp.
 | 
Pages: 1
Prev: Version Updates
Next: A Great Big Thank You!