Do Not Allow Open Queries |
Force the use of a search condition by not allowing open queries. Background You can enforce the use of at least one query condition in a window by setting the Allow Open Query property to Off (default On). When to use Enforce a search condition within windows that are based on large tables. This way you prevent the user from issuing a Query All Records command accidentally. To enforce the user to enter a search condition in a window:
Limitations If you limit query activity using the Allow Open Query property, it will still be possible for the user to use the %-wildcard. |