Default value doesn't update when date is changed

[TheHarleygirl2005]

I have an Attendance date on my form with a default value of =Date()


I also have an Expiration date field with a default value of =DateAdd("yyyy",1,[AttendanceDate])

These are working fine, however there are occasions when I need to change the Attendance date from today's date to something else (the date the course was taken) and I need the Expiration date to automatically update to one year from the new date. I'm guessing I just need to add a refresh or update code to the form but I'm unsure where to do that. Can you help?

[June7]

Cannot 'refresh' DefaultValue. DefaultValue property only executes when record is created, not when record is later edited. This is why should not save calculated value to table - data gets 'out of sync'. As much as possible, save raw data and do calcs when needed.

Saving calculated value requires code that actually replaces the field value.

[Missinglinq]

In the AfterUpdate event of the AttendanceDate Control, use the code

Me.ExpirationDate =DateAdd("yyyy",1,Me.AttendanceDate)

This will only replace the date if you physically enter the date in AttendanceDate.

And June7 is exactly right; the ExpirationDate Control should be Unbound, i.e. should not be saved in the underlying Table!

Linq ;0)>

[TheHarleygirl2005]

This worked perfectly. My ExpirationDate is Unbound. It's located on a form where I enter information. Then I use a command button to run an Append Query which saves the info to another table. Thank you for your help!

[Missinglinq]

Glad we could help!

Linq ;0)>