I have an Access 97 database that has several forms. One set of the fields, on the forms, relates to Boards Members. I am trying to set up an event 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.
I have used the Event Procedure on the start date that is executed on AfterUpdate. I put in the following code:
Me.End_Date_Label = DateAdd("yyyy", 3, Me.Start_Date_Label)
However, when I test it, I keep getting the debug manager.
Any help would be greatly appreciated.