Access/VBA Tutorials - Build a search criteria form. Microsoft Access Tips for Serious Users Provided by Allen Browne, June 2006, updated March 2007.
A flexible search form provides several boxes where a user can enter criteria. An efficient search form creates the criteria from only those boxes where the user enters a value. Download the search database (23KB zipped). It illustrates how to use: Access/VBA Tutorials - Use a multi-select list box to filter a report. Peter's Software.