Filter by Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Donna - 05 Apr 2005 14:19 GMT

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.

Donna wrote:

> 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"

Reply to this Message

Rick Brandt - 05 Apr 2005 15:08 GMT

> 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).

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message