goesnowhere
Technical User
Access 2003 ADP(Access 2000 File Format), SQL Server 2000 backend
I have created a simple form, using the standard functionality in Access.
When using the following standard toolbar buttons
Filter by Form
I enter SMITH into the last_name field
Apply Filter
Get my results
Remove Filter/Sort
However, when I click on Filter by Form to do another filter, the previous criteria LAST_NAME = SMITH still exists.
Is there a way to clear these criteria from the form filter fields when the Remove Filter/Sort button is clicked on or when the Filter/Form button is selected again.
Thanks.
I have created a simple form, using the standard functionality in Access.
When using the following standard toolbar buttons
Filter by Form
I enter SMITH into the last_name field
Apply Filter
Get my results
Remove Filter/Sort
However, when I click on Filter by Form to do another filter, the previous criteria LAST_NAME = SMITH still exists.
Is there a way to clear these criteria from the form filter fields when the Remove Filter/Sort button is clicked on or when the Filter/Form button is selected again.
Thanks.