Calculated age field not populating after 1/1/09

[G.]

I have a form with 3 subforms. On the form I have a "Date of Birth" field
that is manually populated and then I have an "Age" field that calculates the
age. The formula for the Age field is =Int((Date()-[birthdate])/365.25) and
it works fine on the form - The Age field is populated on all of the records
in the form. All 3 subforms have an "Entry Date" field that is manually
populated with the date that the particular record was entered. When I go to
the table or try to create a query and select the Age field as one of the
fields in the query, some of the ages are missing - the field is blank. In my
quest to figure out what is happening I managed to narrow it down and saw
that all of the Age fields in any record entered on or after 1/1/09 are
blank, whereas the others are all there (again, the Age field IS populated in
the form itself though, it is just not getting to the table). Please help.

thank you,
G.

 

[Daryl S]

check to make sure the Age field on the form is bound to the corresponding
field in the database. Also, when does the age get calculated? The age
needs to be calculated before the record is saved.