EESubforms.png

<div>
FYI - Now() gives you &nbsp;date + time which may cause trouble as a filter. &nbsp;Date() gives you only date.
</div>


<div>
<div class="content wysiwyg-content">
Hello, I have a Form called [Excursion Assignment] which uses a subform datasheet called PaxExcursions with a datafield DATES. I now need to apply a filter from a button in the main form to set DATES=NOW()+3…. Thank you so much for any help… Michael
</div>
</div>


Hello, I have a Form called [Excursion Assignment] which uses a subform datasheet called PaxExcursions with a datafield DATES. I now need to apply a filter from a button in the main form to set DATES=NOW()+3…. Thank you so much for any help… Michael

set filter to a subform datasheet from a main form button

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.