I have a form which displays a basic table (personal_information) which has fields holding peoples information - eg name, address, DOB.
When viewing the form of the table (personal_information), I want a text box called 'age' to automatically display the age of the person from their DOB and save it into the personal_information table, thus completing their name, address, DOB and now age.
1)Table called Personal_information - Name(complete), address(complete), dob(01/01/90), age(empty)
2)Run the Form of the table personal_information with empty age
3)Automatically update and save the table while the form is open to calculate and save the age in the personal_information table.
Ive got a query of the table to work out the age and ive created a form of it, but the query doesnt save the age into the original personal_information table.
Any help for a beginner?
Last edited by moss2076; 08-28-04 at 19:36.
Reason: spelling mistake