As of now, I have a database with about 10000 records and about 60 descriptor columns. All of the columns are used, but not every time for every record. Some are used on a few records, but still necessary. Anyway, I have created a form with access to about 30 fields. Then, I have been performing a filter by form to find data that meets specific criteria and then saving the filter as a query to keep my records. However, many times I perform searches and come up with no matching records. This is due to the fact that every field has differing entries and descriptions almost every time.
QUESTION: Is there any way I can make the filter by form, the form in general, or table, update my options to filter by every time I select one individual filter in the "filter by form"? (Example: I have 30 different options altogether of column B to choose from in the drop down list in my "filter by form". However, 1 certain entry from column a is repeated many times and overall, matches with 10 of those distinct entries from column b. Now when I try to perform the filter and I select that entry for column a, can I make the drop down filter box only show those pertinent 10 items that could possibly match with the column a entry, or will it always show EVERY entry, EVERY time.
Please, if anyone has any suggestions, let me know. gunnar.bergeson@motorola.com

QUESTION: Is there any way I can make the filter by form, the form in general, or table, update my options to filter by every time I select one individual filter in the "filter by form"? (Example: I have 30 different options altogether of column B to choose from in the drop down list in my "filter by form". However, 1 certain entry from column a is repeated many times and overall, matches with 10 of those distinct entries from column b. Now when I try to perform the filter and I select that entry for column a, can I make the drop down filter box only show those pertinent 10 items that could possibly match with the column a entry, or will it always show EVERY entry, EVERY time.
Please, if anyone has any suggestions, let me know. gunnar.bergeson@motorola.com




