Hello!
So I have a form set up with member profile data and below it, a subform where I enter donations. What used to happen is that whenever I added a donation to the subform, the anniversary date in the profile area would change to one year from that day's date. So if my anniversary is 9/15/2014 and I give money on 9/10/2014, my anniversary date automatically changes to 9/10/2015.
The anniversary date field is in one table and the donation data is in another. It still works in the old version of the database, but I can't find anything in the VBA or the field properties that accounts for the auto-update except this "=DateAdd("yyyy",1,Date())" in the default value of the Anniversary date field property. But it's the exact same in the new version and the old one works and the new one doesn't.
Am I looking in the wrong places?
Thank you.
So I have a form set up with member profile data and below it, a subform where I enter donations. What used to happen is that whenever I added a donation to the subform, the anniversary date in the profile area would change to one year from that day's date. So if my anniversary is 9/15/2014 and I give money on 9/10/2014, my anniversary date automatically changes to 9/10/2015.
The anniversary date field is in one table and the donation data is in another. It still works in the old version of the database, but I can't find anything in the VBA or the field properties that accounts for the auto-update except this "=DateAdd("yyyy",1,Date())" in the default value of the Anniversary date field property. But it's the exact same in the new version and the old one works and the new one doesn't.
Am I looking in the wrong places?
Thank you.
