Thanks!! I will give it a try.

I think my problem is similar. I have a form with several subforms on different tabs. I created command buttons to open the subforms if the item does not appear in the lookup list in the main form. For example, Upon entering a person's information, when you get to the school field and the school you need is not listed, there is a command button to Add School (which calls on a macro that simply opens school subform). It allows the user to add...

In Access 2003, with the mdb file open, from the File menu, click on Back Up Database . It will ask where to put the backup file....

Age calculation module

New to VBA code and this worked PERFECTLY!
Thank you!!

_______________ _______________ _______________ ______________

Re: Automatic age calculation
--------------------------------------------------------------------------------

I use this slightly longer code, but it returns the age as "15 Years 4 Months" for example.
...