Filter by Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
Click to expand...

Tools
- Options
- Filter By Form Defaults
"Don't display lists where more than this number of records
exists"
 
Donna said:
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.
Click to expand...

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