Problem with birthdate calculation.

[Rusty]

I took a existing database and chanded the birthdate and age feild to
automatically calculate the age with ControlSource propeperty in the
form view. Now the age doesnt show up in the Table view.

The ages are being calculated in the form but do not change in the
table.

Help !

Rusty

 

[John Vinson]

I took a existing database and chanded the birthdate and age feild to
automatically calculate the age with ControlSource propeperty in the
form view. Now the age doesnt show up in the Table view.

The ages are being calculated in the form but do not change in the
table.

This is EXACTLY HOW IT SHOULD BE.

If you store the Age field in the table you can guarantee that in 366
days *every single record in the table will contain incorrect data*.

Just calculate the Age as needed, on the fly, in a Query or on the
form or report. It need not and *should not* be stored in the table at
all.