Hi Rachel,

Is the control you are using to display the returned calculated date
bound to a field in the table in which the other data on the form is
stored? There might be a slight issue with saving this information in
your table as the data will represent the age at the time when the
record was created (and therefore would remain static) unless changed.
You may want it to do this...or you may not. Another alternative would
be to recalculate the age each time you wish to view the age in order
to show the persons age each time you view it. Hope this helps...will
check back to see how you go :)

Anton

It is not a good idea to store a value that you can calculate in a query,
form, report, or VBA code when you need it. If you have a need to store "the
person's age when data about him/her was first entered", it would be valid.
In that case, use VBA code to copy the calculated value into a Text Box that
is bound to the appropriate Field in the Record Source.

If it just represents the person's age, that will change over time... and
can always be calculated from the saved DOB.

 Larry Linson
 Microsoft Access MVP