Trouble with Filter By Form updating data

[gunwax]

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

 

[WayneRyan]

gun,

What you are describing are "cascading comboboxes". Use the Search facility
here. It's a common topic. Might even look for just "cascading".

Wayne

 

[gunwax]

thanks wayne, ill give it a shot