ACC: How to Dynamically Create a Filter (109334)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q109334
Moderate: Requires basic macro, coding, and interoperability skills.
SUMMARY
This article describes a method of dynamically creating a filter by
applying expressions on a form using a macro. The same technique can
also be adapted to a Query by Form (QBF) method.
NOTE: Although this article will work with Microsoft Access 7.0 and
97, a new feature has been introduced called Filter by Form. For
more information on this new feature, query on the words "Filter by Form"
using the Microsoft Access 97 Help Index.
Modification Type: | Major | Last Reviewed: | 5/6/2003 |
---|
Keywords: | kbhowto kbusage KB109334 |
---|
|