<div>
or possibly<br />
<br />
DoCmd.OpenForm &quot;&nbsp;Form_Projects&quot;, , , &quot;[Date] &gt;= &quot;#&quot; &amp;&nbsp;Date()-10 &amp;&nbsp;&quot;#&quot; And [Date] &lt;= &quot;#&quot; &amp;&nbsp;Date()+30 &amp;&quot;#&quot;&quot;
</div>


or possibly

DoCmd.OpenForm " Form_Projects", , , "[Date] >= "#" & Date()-10 & "#" And [Date] <= "#" & Date()+30 &"#""

<div>
Roy's first solution and Dale's suggested solution worked fine. Dale, your points are well made. Thank you both !
</div>


Roy's first solution and Dale's suggested solution worked fine. Dale, your points are well made. Thank you both !

<div>
<div class="content wysiwyg-content">
I am an MS Access beginner using version 2013. A button opens a continuous form that I would like to filter for records in the range of ten days before the current date and 30 days after the current date (i.e. a 40-day period). I have tried various pieces of code for the button's on-click event, including the following, but just cannot get it to work.<br />
<br />
DoCmd.OpenForm &quot;&nbsp;Form_Projects&quot;, , , &quot;Date= Between Date()-10 And Date()+30&quot;<br />
<br />
The expression Between Date()-10 And Date()+30 works fine in queries, but not in VBA, as I keep getting an error message telling me the code structure is wrong. Could anyone help point me in the direction of the correct VBA expression that should be used ?
</div>
</div>


I am an MS Access beginner using version 2013. A button opens a continuous form that I would like to filter for records in the range of ten days before the current date and 30 days after the current date (i.e. a 40-day period). I have tried various pieces of code for the button's on-click event, including the following, but just cannot get it to work.

DoCmd.OpenForm " Form_Projects", , , "Date= Between Date()-10 And Date()+30"

The expression Between Date()-10 And Date()+30 works fine in queries, but not in VBA, as I keep getting an error message telling me the code structure is wrong. Could anyone help point me in the direction of the correct VBA expression that should be used ?

Filtering a Continuous  Form by Date Ranges in VBA

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.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.