#Name? error showing in Text box.

[yes sir]

When I sent a copy of my database to another person (zipped the file, he extracted the files, he saved it on his desktop) there is a field on one of the forms that determines someone's age based on the date given.

The field computes properly on my laptop and on another desktop here at the house, but when he opens it on his computer the Age field on the form displays as : #Name?

Anyone know what is going on here?

Here is the expression entered for the Control Source, I had him check his, and it is the same:


=DateDiff("yyyy",[DoB],Now())+Int(Format(Now(),"mmdd")<Format([DoB],"mmdd"))

[pbaldy]

I'd suspect a reference problem:

Access Reference Problems

[yes sir]

Problem fixed.

I had to go to the record source for the form and add a column like this:

Age: DateDiff('yyyy',[nameoftable]![DateofBirth],Date())