Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Newbie Question: Refreshing/Clearing Form Content Criteria

Status
Not open for further replies.

goesnowhere

Technical User
Feb 23, 2004
16
CA
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.









 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top