<div>
No, I wasn't trying to hard-code the date. I'm just trying to create the button so a user can filter the form. But I guess I can just show them how to use &quot;filter by form&quot; button that is on the tool bar menu. Thanks.
</div>


No, I wasn't trying to hard-code the date. I'm just trying to create the button so a user can filter the form. But I guess I can just show them how to use "filter by form" button that is on the tool bar menu. Thanks.

<div>
<div class="content wysiwyg-content">
I have created a form in Access. On this form I want to create a &quot;action button&quot; which would apply a filter of the information that is viewable. I have 18 records, and I only want to see the ones that have a date of 5/1/07 associated with it. I know how to create the button while in design view, I just don't know what to do on the &quot;build event&quot; part to perform the filter action.
</div>
</div>


I have created a form in Access. On this form I want to create a "action button" which would apply a filter of the information that is viewable. I have 18 records, and I only want to see the ones that have a date of 5/1/07 associated with it. I know how to create the button while in design view, I just don't know what to do on the "build event" part to perform the filter action.

Access, action button, filter form

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.