Hi, I've got an autofill issue if anyone can help.
I've got a Form called EntryForm. One field, called CBT Exam Date, is entered. Another field called, Anniversary Date, should be autofilled depending on the date in CBT Exam Date. It should be three years minus one day from CBT Exam Date. Now, I'm setting the After Update property of CBT Exam Date to run a macro called CBTAutoFill. In this macro I'm trying to use DateAdd but it's only adding days. With leap years and other calender craziness, I need to use Years instead of a set number of days. I tried to change DateAdd("d",amount,[Control]) to
DateAdd("y",amount,[Control]) but it still just adds days. Also, I am kind of lost on subtracting the one day. ???? Any help out there?
Item: [Forms]![EntryForm]![Anniversary Date]
Expression: DateAdd("y",3,[Forms]![EntryForm]![CBT Exam Date])
Need to change Expression....
Thanks all
Beginner
I've got a Form called EntryForm. One field, called CBT Exam Date, is entered. Another field called, Anniversary Date, should be autofilled depending on the date in CBT Exam Date. It should be three years minus one day from CBT Exam Date. Now, I'm setting the After Update property of CBT Exam Date to run a macro called CBTAutoFill. In this macro I'm trying to use DateAdd but it's only adding days. With leap years and other calender craziness, I need to use Years instead of a set number of days. I tried to change DateAdd("d",amount,[Control]) to
DateAdd("y",amount,[Control]) but it still just adds days. Also, I am kind of lost on subtracting the one day. ???? Any help out there?
Item: [Forms]![EntryForm]![Anniversary Date]
Expression: DateAdd("y",3,[Forms]![EntryForm]![CBT Exam Date])
Need to change Expression....
Thanks all
Beginner
