Generated Date from previous cell, need option to override

[Pamoola55]

An add on to Doug's question,

I have a form on Access with 2 fields. Date1 and Date2. Usually Date2 is 1 year ahead Date1. So I would like an expression that when I type Date1, Date2 would be automatically filled with Date1 + 1 Year.

I have several fields that are calculated dates from previous fields. Here's the problem: there are times that I need to override those cells with either a blank (backspace or delete) cell, or to write over the calculated date with a different date. Possible?? How?? (simple to moderately-simple answer needed). Thx.

[RuralGuy]

You'll notice I moved your post to a new thread. By way of an answer, if the "calculated" dates are calculated in the AfterUpdate event of the 1st control then you can easily update the "calculated" control.

[Pamoola55]

OK..I'm going to update my "simple to moderately-simple answer needed" to "really simple answer needed."
thanks for putting the post where it needs to go.

[RuralGuy]

When the user changes a value in a control on your form and moves the focus to another control, an AfterUpdate Event fires for the control you are leaving. You can put code in this event that will use the value of the control you are leaving to update another control on your form with a calculated value. If you move to the control with the now calculated value in it, you can change it to anything you want. Need more assistance? Just give us more details and we can supply the code if that is what you need.