I have an Access 97 database. I have several forms created. One set of fields on the forms relates to Board Members. I would like to set up a macro that will allow the Board Member to fill in his/her term start date and upon exiting the field Access will autofill in the term end date, which would be 3 years out.
Can this be done? Any help would be greatly appreciated.
