<div>
<br />
<br />
Me.YouDateTextBox = DateAdd(&quot;yyyy&quot;,-2 , Date())<br />
<br />
mx
</div>




Me.YouDateTextBox = DateAdd("yyyy",-2 , Date())

mx

<div>
<div class="content wysiwyg-content">
When my form opens, I would like to populate a text box with the current date - 2 years. &nbsp;What is the syntax for that please?
</div>
</div>


When my form opens, I would like to populate a text box with the current date - 2 years.  What is the syntax for that please?

Calculate a date field

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.