DateDiff Error
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.
|