By executing a SQL statement. Using DAO ...
CurrentDb.Execute YourSQLStatementHere
.... or using ADO ...
CurrentProject.Connection.Execute YourSQLStatementHere
What goes in 'YourSQLStatementHere' depends on information that is not
available to me, such as whether you are adding a new record or updating an
existing one.
BTW: It is generally best to record date of birth rather than age. Date of
birth doesn't change, age does. Given a person's date of birth, you can
calculate their current age whenever needed.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
