Filtering a Query

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

I have a query based on relationships. After running the
query, I like to additionally use Filter By Form. When I
click on any field, it gives me 2 options (Is Null and Is
Not Null)instead of giving me a list of items relating to
that field field.

At present, I type in the values into the Filter by form
field manually and it seems to work ok. However, I would
like to see the values automatically if possible

Any reasons as to why this could happen and is there a
solution?.
 
Jon said:
I have a query based on relationships. After running the
query, I like to additionally use Filter By Form. When I
click on any field, it gives me 2 options (Is Null and Is
Not Null)instead of giving me a list of items relating to
that field field.

At present, I type in the values into the Filter by form
field manually and it seems to work ok. However, I would
like to see the values automatically if possible

Any reasons as to why this could happen and is there a
solution?.
Click to expand...

Hi Jon,

Under the tab "Edit/Find" when you select "Tools/Options"
from the menubar, there is a setting for :

"Don't display lists where more than the number of records read:"

It appears that the default is 1000.

It also appears that if you then have more than 1000 values (records),
you will get this "Is Null" list in your dropdown list when you try to
use Filter-By-Form drop-down arrows.

Changing the value to a value greater than the number
of records you will have (what that will be may be
"expensive") allows the filter-by-form dropdown lists
to work correctly.

Please respond back if I have misunderstood.

Good luck,

Gary Walter
 
Back
Top