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.
But that is usually. Not always.
In the field Date2, properties, Event and On Get Focus, I put the following expression:
Iīm sure the expression is working correctly because if I put it on DefaultValue or Control Source, it works perfectly. The problem is that if I put on DefaultValue the expression triggers when I open the form, and when I open the form the field Date1 is empty. And if I put on Control Source I canīt change the value.Code:=DateSerial((Year([Date1])+1);Month([Date1]);Day([Date1]))
I also already tried to put it on On Enter, On Click, everything. It doesnīt work.
The format is DD/MM/YYYY.