after update stopped working

  • Thread starter Thread starter Biiglad
  • Start date Start date
B

Biiglad

Hello I wonder if any one can help me.
ms access 2000, pro win xp home
I use a form in datasheet view to enter dates of death, ages of death and
date of birth.
I calculate year of birth if no date of birth by the following code in the
after update event of the year of birth field
YoB = YEAR(DoD) - AoD
Year of birth = year of death - age of death -- in english
this worked fine until a few days ago and has now stopped working.
Any help will be greatly appreciated
Thanks in advance
 
The expression looks okay.

Did you recently add something (e.g. a field) named Year? If so, the object
and the function name may be conflicting. If so, it would be better to
rename the object, but you could get away with:
YoB = VBA.Year(DoD) - AoD

If that is not the issue, you may have a problem with references. See:
http://allenbrowne.com/ser-38.html
 
Hello
thank you for you reply
I did do some messing but can't remember what I did
will try out your suggestion
thank you very much
Best Regards
 
Back
Top