Calculate Age Automatically

[Leaner79]

Hi,

I have a form that has a bunch of fields. The 2 major fields i'm most concerned with for now are the ones for date.
Age - Should contain the age of the person
DOB - should contain the date of birth of the person

The Age should be calculated automatically by subracting the DOB from the System Date.

Please Help

 

[ZmrAbdulla]

Look for "DateDiff()" in the help.
Also there are numerous threads and FAQs here on the same subject.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[Leaner79]

Thanx Zameer,
I worked.
i have 1 more question. How do i get it to calculate it automatically, everytime a record is opened.
The way i tried using On Open doesn't work coz if i open to add a new record, i get an error.

NB.
For existing records only. When i preview, the age should be calculated automatically.

 

[ZmrAbdulla]

What type of error you are getting?


________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.