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.
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.
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.
ASKER