Filter by Form

[Donna]

RICK, I went to the Tools/Options area and changed the number in that box
from 1000 (default value) to 10000 since I don't think we'll reach that value
soon. That did not help. The values that show in a field in the Filter by
Form still only show IS NULL, IS NOT NULL.

I have a table within a database that I want to filter. However,
when I choose Filter/Filter by Form and click the drop down menus in
the fields I want to use in the filter, the only options are IS NULL
or IS NOT NULL. EXCEPT for only one of the fields which gives me a
list of the options that match the values in that field.

How do I set up my table so that I can filter for data in ANY of the
fields?

Tools
- Options
- Filter By Form Defaults
"Don't display lists where more than this number of records
exists"

 

[Rick Brandt]

RICK, I went to the Tools/Options area and changed the number in that
box from 1000 (default value) to 10000 since I don't think we'll
reach that value soon. That did not help. The values that show in a
field in the Filter by Form still only show IS NULL, IS NOT NULL.

Apparently it works exactly as advertised, but only if the table is local
(it cannot be a linked table).